SQLState errors during sync

[Former Member]

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

[Former Member]

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