Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

How I can find root cause for this error?

(0) ShareShare
ReportReport
Posted on by 253
Dear All,
 
I got some error in my environment and when I run my code everything sound run normally. Can someone guide me how to solved?
 
 
  • Suggested answer
    Chomchanok Profile Picture
    Chomchanok 253 on at
    How I can find root cause for this error?
    Dear All
     
    Thank you for your kindly comment for this forum. Now I got a solution already.
    I clean up solution and re-build again and now it's work.
     
    Again thank you for all your.
     
    BR
     
     
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    How I can find root cause for this error?
    Try doing model build and then do database sync. That should solve.
  • Chomchanok Profile Picture
    Chomchanok 253 on at
    How I can find root cause for this error?
     
    For DB synchronization, i do at first time i got an error but it still happen.
     
    Do you have any suggestions please?
  • Martin Dráb Profile Picture
    Martin Dráb 230,848 Most Valuable Professional on at
    How I can find root cause for this error?
    The first thing to try is running DB synchronization.
  • Chomchanok Profile Picture
    Chomchanok 253 on at
    How I can find root cause for this error?
    {Query HSTHLedgerJournalTableTrans object 296ddfb0: SELECT * FROM LedgerJournalTable(LedgerJournalTable) WHERE ((JournalNum = N'JN19011145')) JOIN * FROM LedgerJournalTrans(LedgerJournalTrans) ON LedgerJournalTable.JournalNum = LedgerJournalTrans.JournalNum}
  • Chomchanok Profile Picture
    Chomchanok 253 on at
    How I can find root cause for this error?
    Dear RudyZhang
     
    Thank your for your kindly reply. I try to follow up by check my table and We found it's not a field "HSTHPAYMENTMETHODCODE" so I add field "HSTHPAYMENTMETHODCODE" in my table
     
    and I try to re-build and start with debugging again.
    and I got an error like this. 
     
    but when I check value in my variable qr is "{Query HSTHLedgerJournalTableTrans object 296ddfb0: SELECT * FROM LedgerJournalTable(LedgerJournalTable) WHERE ((JournalNum = N'JN19011145')) JOIN * FROM LedgerJournalTrans(LedgerJournalTrans) ON LedgerJournalTable.JournalNum = LedgerJournalTrans.JournalNum}"
     
    and when I check output page with JN19011145 that match my record. Everything should work but It's not.
    Can you guide me?
     
  • Suggested answer
    RudyZhang Profile Picture
    RudyZhang Microsoft Employee on at
    How I can find root cause for this error?
    Hi,
     
    Based on the error screenshot you gave, our team found that this may be caused by some errors generated by the ODBC Driver.
     
    Please double check if there is a HSTHPAYMENTMETHODCODE column in your Table, according to the error message it is an invalid column name

     
    In addition, could you please provide more information about the error or tell us exactly what your code does? The information you provide will help our team to locate the cause of your error faster
     
    I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.
     
    Best Regards,
    Rudy Zhang
  • Chomchanok Profile Picture
    Chomchanok 253 on at
    How I can find root cause for this error?
     
     
     

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans