News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Cannot select a record...

Microsoft Dynamics AX (Archived)

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

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 Img

All responses (1)

Answers Img

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans