Skip to Content
avatar image
Former Member

SQLState errors during sync

Hello,

I am getting the following sqlstate error during download of certian equipment/funct. locations in MAU 3.0 MI 7.0

Any Idea what is causing this?

Thanks in advance

[20080607 20:01:57:717] E [MI/Persistence ] insert: insert into M14_cUMAM30_031_TO values ( 5,48419870A12717B7E1000000927BC043,31891630,300000000000021832,700000001216,700000001216,',U,IE300000000000021832,W549150,000000000000000015,',W549150,',',',NULL,0,16M175 Series B3 Rotary Gas Meter, TC,',ZMTRPROF,',Walnut St 900,',',US,',',0,0E-12,0E-12,0.000,',0,300000000000021832,700000001216) - error code: -104 SQL state: 42601 Message: 0E [SQLState:42601, error code:-104]

[20080607 20:01:57:717] E [MI/Smartsync ] Inbound processing of container with index 3814 failed: 0E [SQLState:42601, error code:-104] : <InboundProcessingError timestamp="2008-06-07-16-01-57"><RowProcessorDispatcherDump type="obsoervable" ><Action>a</Action><TopRowKey>0031891630</TopRowKey><ChildRowKey> </ChildRowKey><RequestId> </RequestId><StateID> </StateID></RowProcessorDispatcherDump></InboundProcessingError>

Edited by: ez on Jun 7, 2008 10:11 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 09, 2008 at 01:50 PM

    Hi,what support level of MI are you using and what is the version of DB2e? Check for notes and updates. the mentioned error is an SQL error with a wrong statement. So it could be one of the three involved components that is wrong:

    - MI

    - DB2e

    - MAM

    Check for latest version and for patches. Be aware that you can not run a higher SP level on the MI client side then you have installed on MI Middleware server.

    Hope this helps to get yu an idea how to solve this issue.

    Regards,

    Oliver

    Add comment
    10|10000 characters needed characters exceeded