Skip to main content

Notifications

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 []

Posted on by 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

  • Heine Profile Picture
    Heine 5 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans