Re: [Karmatool-users] Adding workflow via RabbitMQ?

[Devarshi G. <dgh...@um...>]

Hi Michael,

The user-manual describes giving grants to the mysql metadata table 'proc'
as shown below:
*GRANT SELECT, INSERT, UPDATE ON `mysql`.`proc` TO '<user>'@'<hostname>';*

The error should be a result of not having the required grants to the table.

Let us know if the error persists.

You might also try giving the following grant in case the grant statement
above doesn't resolve the issue:
GRANT EXECUTE ON PROCEDURE karma.PR_OBJECT_LOCK TO '<user>'@'hostname';


On Fri, Mar 15, 2013 at 1:20 PM, Black, Michael (IS) <Mic...@ng...
> wrote:

>  I found this in the karma.log if it helps.
>
> 15 Mar 2013 13:14:16,052 [Thread-7] INFO
> edu.indiana.dsi.karma.messaging.NotificationReceiverRunnable  -[Karma
> server: Listening to Messaging System]
> 15 Mar 2013 13:14:16,503 [AsynProc-0] INFO
> edu.indiana.dsi.karma.ingest.db.BaseDBIngester  -Store invocation
> 15 Mar 2013 13:14:16,503 [AsynProc-0] DEBUG
> edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer
> -manageDBLock-Error: SQLException during call to PR_OBJECT_LOCK:User does
> not have access to metadata required to determine stored procedure
> parameter types. If rights can not be granted, configure connection with
> "noAccessToProcedureBodies=true" to have driver generate parameters that
> represent INOUT strings irregardless of actual parameter types.
> 15 Mar 2013 13:14:16,503 [AsynProc-0] ERROR
> edu.indiana.dsi.karma.ingest.db.BaseDBIngester  -Unable to process raw
> notification with internalID 855
> java.lang.NullPointerException
>         at
> edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.manageDBLock(BaseDBIngesterImplementer.java:3814)
>         at
> edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.insertEntityRecord(BaseDBIngesterImplementer.java:3752)
>         at
> edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.saveInvocation(BaseDBIngesterImplementer.java:4073)
>         at
> edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.saveInvocationStatus(BaseDBIngesterImplementer.java:2396)
>         at
> edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer.storeInvocationStatus(BaseDBIngesterImplementer.java:4109)
>         at
> edu.indiana.dsi.karma.ingest.db.BaseDBIngester.invokedProcessHelper(BaseDBIngester.java:1210)
>         at
> edu.indiana.dsi.karma.ingest.db.BaseDBIngester.processWorkflowInvoked(BaseDBIngester.java:1184)
>         at
> edu.indiana.dsi.karma.ingest.db.BaseDBIngester.processNotifications(BaseDBIngester.java:937)
>         at
> edu.indiana.dsi.karma.ingest.AsyncRawNotificationProcessor.run(AsyncRawNotificationProcessor.java:116)
>         at java.lang.Thread.run(Thread.java:736)
> 15 Mar 2013 13:14:16,504 [AsynProc-0] DEBUG
> edu.indiana.dsi.karma.ingest.db.BaseDBIngesterImplementer  -Number of
> entries marked ERROR: 1
>
>
>
>  Michael D. Black
> Senior Scientist
> Analytics, Production and Services
> Advanced GEOINT Systems
> Northrop Grumman Information Systems
>    ------------------------------
>
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar
> _______________________________________________
> Karmatool-users mailing list
> Kar...@li...
> https://lists.sourceforge.net/lists/listinfo/karmatool-users
>
>


-- 
Thanks & regards,
Devarshi