Cannot select a record in Route segment (TMSRouteSegmentTable). The SQL database has issued an error, Unable to retrieve message for retval -1, ODBC call reason code 100, SQLSTATE = [] Error message []

(0) Share

Report

Posted on by B K Sharma

735

Hi Experts,

Getting below error when load creation in ax 2012, Full Compile, Full CIL, DB Sync and Index recreation done for the table

Cannot select a record in Route segment (TMSRouteSegmentTable). The SQL database has issued an error. Object Server 01: [Microsoft Dynamics AX] Unable to retrieve message for retval -1, ODBC call reason code 100, SQLSTATE = [] Error message [] SELECT T1.CURRENCYCODE FROM TMSROUTESEGMENTTABLE T1 WHERE (((PARTITION=?) AND (DATAAREAID=?)) AND (((REFTABLEID=?) AND (REFRECID=?)) AND (ROUTEID=?))) GROUP BY T1.CURRENCYCODE ORDER BY T1.CURRENCYCODE session 16 (UserId)

*This post is locked for comments

All responses (1)

Answers (0)

Heine 5 on at

Like (0)

Report

RE: Cannot select a record in Route segment (TMSRouteSegmentTable). The SQL database has issued an error, Unable to retrieve message for retval -1, ODBC call reason code 100, SQLSTATE = [] Error message []

Hi. Did you find a solution to your problem with Unable to retrieve message for retval -1, ODBC call reason code 100, SQLSTATE = [] Error message [

I have exact same problem now, and can´t find a solution that works

Best regards

Heine Lehmann

hlj@3cretail.dk