System Error

[erprider]

Hi Guys

I've been getting this error when i open the Batch
list all batchlist(AP,AR,GL) "System Error.Writedown the message,error and source codes.Exit ACCPAC and windows.Restart and retry the operation.for information,see Appendix A in the system manager User guide"

By way this error occurs only in the Server Guys not in the client PC's.

any one know why its happening like this?

Sage Accpac 5.4A SP2
MS-SQL 2005
Windows 2003 Server


Thank you in advance

 

[shaccpac]

Pls run data intigrity & try

 

[Jay Converse]

Data integrity will show nothing, this is a program problem. First run Workstation setup from Add/Remove programs, then run REGACC.

 

[erprider]

Thanks for the reply

But its not happening in the client PC it's happening only for the Server

 

[Jay Converse]

My answer doesn't change.

 

[erprider]

Data Integrity Log (AS4000)
YOUSUF A.WAHAB AL HAWAJ & SONS CO. WLL
Page: 2
20/04/2009 3:13:02PM
G/L Account Mappings
0 Error(s) found in G/L Account Mappings.
Segment Codes
0 Error(s) found in Segment Codes.
Revaluation Codes
0 Error(s) found in Revaluation Codes.
Account Groups
0 Error(s) found in Account Groups.
Accounts, Fiscal Sets, Posted Transactions, Account Allocation Instructions, Control Account Subledgers, Account Valid Currencies
E: Posted Transaction.
Database error (operation=GET-NEXT, error=0).
[Microsoft][SQL Native Client]Invalid character value for cast specification Please refer this error to your database administrator or see your database documentation for further assistance.
E: Internal error. GLPOST: viewFetch failed (3445 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.
E: Internal error. Error in FetchGLPOST. (3589 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.
3 Error(s) found in Accounts, Fiscal Sets, Posted Transactions, Account Allocation Instructions, Control Account Subledgers, Account Valid Currencies.
Optional Fields
0 Error(s) found in Optional Fields.
G/L Subledger Services 5.4A (April 20, 2009 15:12:57)
GL Subledger Transactions
0 Error(s) found in GL Subledger Transactions.
GL Subledger Entries
0 Error(s) found in GL Subledger Entries.
GL Subledger Details
0 Error(s) found in GL Subledger Details.
GL Subledger Detail Opt. Fields
0 Error(s) found in GL Subledger Detail Opt. Fields.
Batch/Entry Matching
0 Error(s) found in Batch/Entry Matching.
7 Error(s) found in Common Services 5.4A
3 Error(s) found in General Ledger 5.4A
10 Error(s) in Total (April 20, 2009 15:12:57)

This is the data Data Integrity Log (AS4000)
YOUSUF A.WAHAB AL HAWAJ & SONS CO. WLL
Page: 2
20/04/2009 3:13:02PM
G/L Account Mappings
0 Error(s) found in G/L Account Mappings.
Segment Codes
0 Error(s) found in Segment Codes.
Revaluation Codes
0 Error(s) found in Revaluation Codes.
Account Groups
0 Error(s) found in Account Groups.
Accounts, Fiscal Sets, Posted Transactions, Account Allocation Instructions, Control Account Subledgers, Account Valid Currencies
E: Posted Transaction.
Database error (operation=GET-NEXT, error=0).
[Microsoft][SQL Native Client]Invalid character value for cast specification Please refer this error to your database administrator or see your database documentation for further assistance.
E: Internal error. GLPOST: viewFetch failed (3445 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.
E: Internal error. Error in FetchGLPOST. (3589 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.
3 Error(s) found in Accounts, Fiscal Sets, Posted Transactions, Account Allocation Instructions, Control Account Subledgers, Account Valid Currencies.
Optional Fields
0 Error(s) found in Optional Fields.
G/L Subledger Services 5.4A (April 20, 2009 15:12:57)
GL Subledger Transactions
0 Error(s) found in GL Subledger Transactions.
GL Subledger Entries
0 Error(s) found in GL Subledger Entries.
GL Subledger Details
0 Error(s) found in GL Subledger Details.
GL Subledger Detail Opt. Fields
0 Error(s) found in GL Subledger Detail Opt. Fields.
Batch/Entry Matching
0 Error(s) found in Batch/Entry Matching.
7 Error(s) found in Common Services 5.4A
3 Error(s) found in General Ledger 5.4A
10 Error(s) in Total (April 20, 2009 15:12:57)

this is the integrity report i ran only for the GL because it was give an error when i open the GL Batch list

 

[Jay Converse]

Don't use the Native client driver on version 5.4. Delete your DSN's and recreate them with the classic ODBC driver.

 

[erprider]

By the way i dumped the database from the server and when i was loading the dumb into testing PC i found this error "
INSERT error=49153,native code=0) message:[Microsoft][SQL Native client]Connection is busy with result for another command"

any idea! it would be appreciated..

 

[Jay Converse]

I repeat, don't use the Native client driver on version 5.4.

 

[erprider]

Okay.. thanks for your valuable information tuba2007. let me check and i will try to uninstall that. i hope if i run Regacc and see the issue may be resolve hopefully("System Error.Writedown the message,error and source codes.Exit ACCPAC and windows.Restart and retry the operation.for information,see Appendix A in the system manager User guide"
)

 

[erprider]

Thanks tuba2007..issue has been resolved actually accpac creates its own DSN. databaset up we simmply type the server name i just create one ODBC as you said and linked it and i am using that DSN now its perfect that error hasnt come.