cancel
Showing results for 
Search instead for 
Did you mean: 

"Database disconnected; choose the OK button to exit the database"

AshwinKatkar
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ashwin,

May be your network is fluctuating.. try pinging your server IP and check.

Thanks,

Harshal

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Ashwin,

I think you should close the thread by marking correct answer.

Thanks,

Harshal

AshwinKatkar
Participant
0 Kudos

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.

0 Kudos

hi what did you mean by "added the host names in host file"??

thanks.

former_member227598
Active Contributor
0 Kudos

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

former_member186095
Active Contributor
0 Kudos

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

AshwinKatkar
Participant
0 Kudos

Hi Jimmy,

As i understood from SAP Note that this issue can be fixed by applying patch. Can you please suggest which version of patch can resolve this issue. We are using SAP B1 9.1 PL9.

Regards,

Ashwin

former_member186095
Active Contributor
0 Kudos

Hi Ashwin,

Yesterday, SAP released the SAP B1 9.1 PL12. So, you can upgrade to this new patch

Rgds,

Jimmy