2 Replies - 828 Views - Last Post: 21 September 2012 - 01:41 PM

#1 GWBangi  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 21-September 12

Error on Posting Transactions

Posted 21 September 2012 - 07:36 AM

I need to update tables in SQL but when the system is reaching the end, it pops up the error as below.
TGLTransRecord:Error Posting GL Transaction! Internal Query Processor Error: The query processor encountered an unexpected error during execution.
Is This A Good Question/Topic? 0
  • +

Replies To: Error on Posting Transactions

#2 RudiVisser  Icon User is offline

  • .. does not guess solutions
  • member icon

Reputation: 1002
  • View blog
  • Posts: 3,562
  • Joined: 05-June 09

Re: Error on Posting Transactions

Posted 21 September 2012 - 08:33 AM

This isn't a MySQL error this is a SQL Server error so you're in the wrong forum.

Aside from that, we'd need to see what sort of SQL you're actually running before we can help you to debug it.
Was This Post Helpful? 0
  • +
  • -

#3 e_i_pi  Icon User is offline

  • = -1
  • member icon

Reputation: 789
  • View blog
  • Posts: 1,676
  • Joined: 30-January 09

Re: Error on Posting Transactions

Posted 21 September 2012 - 01:41 PM

Moved to MSSQL. Your error appears to be a caught exception, as the text "TGLTransRecord:Error Posting GL Transaction!" is custom, while the remaining text is MSSQL error text. I would suggest doing a text search through your code for the text I quoted to find where the error is being generated, then look for the query(s) preceding that to locate the buggy script.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1