on 05-03-2016 6:21 AM
Hello Expert,
While using SAP Business One after halt and hour i am getting an error "Database disconnected; choose the OK button to exit the database"
Also if i left the SAP Business One client open for some time and sit idle same error appeared.
Here is the detailed error message from Log file:
Error: -1, Query: SELECT T0.[Code], T0.[Name], T0.[Priority], T1.[QString], T1.[QType], T0.[History] FROM [dbo].[OALT] T0 INNER JOIN [dbo].[OUQR] T1 ON T1.[IntrnalKey] = T0.[QueryId] AND T1.[QCategory] = T0.[QCategory] INNER JOIN [dbo].[ALT1] T2 ON T2.[Code] = T0.[Code] WHERE T0.[Type] = (?) AND T0.[Active] = (?) AND (T0.[NextDate] < (?) OR (T0.[NextDate] = (?) AND T0.[NextTime] <= (?) )) AND T2.[UserSign] = (?) , sqlState: 08S01, nativeErr: 10054, errText:[Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.
# # TID=21768 __DBMC_Statement.cpp 222 Customized=0
02/05/2016 19:50:21:351989 Sys Err I Biz Database disconnected; choose the "OK" button to exit the database # # TID=21768
Hi Ashwin,
May be your network is fluctuating.. try pinging your server IP and check.
Thanks,
Harshal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ashwin,
I think you should close the thread by marking correct answer.
Thanks,
Harshal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello All,
Thank you for valuable responses.
This issue is resolved. It was due to fluctuation in network, i have added the host names in host file.
After that the error is not occurred yet.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ashwin,
Please try to install or upgrade from SAP B1 9.1 PL 09 to SAP B1 9.1 PL 10.
I think u should try with fresh installation with PL 10.
Rgds,
Kamlesh Naware
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
your problem seems affected by this following sap note:
1498738 - Dump file creation when connection to SQL server is lost
The SQL server connection from PC client is failed. So, you must restart your SAP B1 application in the PC and also check the sql server if its service is stopped or not
Rgds,
Jimm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.