Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Brilliant! Your site is great...and saving me hours of time at work and making my boss think I am brilliant too! I also picked up on a thread that will potentially save us a lot of money in the future..."

Geography

Where in the world do Tek-Tips members come from?
trmeupey (IS/IT--Management)
30 Jul 12 10:09
Hi,
I'm facing an error while posting GL batch.
The error message is the following:

"Description: Posted Transaction. Database error (operation=INSERT, error=823). [Microsoft][SQL Server Native Client 10.0][SQL Server]Le système d'exploitation a retourné l'erreur 1(Incorrect function.) à SQL Server pendant une opération de lire au niveau du décalage 0x000002fca98000 dans le fichier 'E:\Accpac\Data\DATA\GADATA.mdf'. V Please refer this error to your database administrator or see your database documentation for further assistance."

SQL 2008 r2
Sage Accpac 5.5 Latest service pack.
ettienne (TechnicalUser)
30 Jul 12 11:07
WTF is your SQL database in a shared folder (E:\Accpac\Data\DATA\GADATA.mdf)?
SQL databases should be in a secure location.
Anyway that is not the issue, you have serious database problems. Have a look here: http://support.microsoft.com/kb/828339
tuba2007 (Programmer)
30 Jul 12 11:07
I hope you have a good backup, SQL error 823 is probably a hardware problem: http://support.microsoft.com/kb/828339
DjangMan (Programmer)
30 Jul 12 11:19
Out of hard drive space?
trmeupey (IS/IT--Management)
30 Jul 12 11:35
Hi Ettiene, Tuba,
just for info, we are using Terminal Server to access Accpac.
Thank you for your feedback.
trmeupey (IS/IT--Management)
31 Jul 12 6:29
Hi All,
I tried to run Data Integrity on Gl and i received the following error message :

Djangman,
No out space issue

"
Optional Fields
E: Internal error. GLINTCK: Error executing the dbQueryRun. (5530 GLINTCK1.C). Write down the message, leave Sage Accpac and
Windows and return to the system prompt. Reset your computer and try the task again. See Appendix A in the G/L User Guide."

How to correct this?

Thank you for your help!
tuba2007 (Programmer)
31 Jul 12 6:34
Look for a good backup.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close