Finance | Project Operations, Human Resources, ...

How I can find root cause for this error?

(0) Share

Report

Posted on by Chomchanok

282

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?

I have the same question (0)

All responses (8)

Answers (0)

Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Suggested answer

RudyZhang Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

{Query HSTHLedgerJournalTableTrans object 296ddfb0: SELECT * FROM LedgerJournalTable(LedgerJournalTable) WHERE ((JournalNum = N'JN19011145')) JOIN * FROM LedgerJournalTrans(LedgerJournalTrans) ON LedgerJournalTable.JournalNum = LedgerJournalTrans.JournalNum}

Was this reply helpful? Yes No
Martin Dráb 238,769 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The first thing to try is running DB synchronization.

Was this reply helpful? Yes No
Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

Dear Martin Dráb

For DB synchronization, i do at first time i got an error but it still happen.

Do you have any suggestions please?

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report
Copy link

Link copied!

Try doing model build and then do database sync. That should solve.

Was this reply helpful? Yes No
Suggested answer

Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No