SAP DB(MSSQL) 연결 불가 (ABAP runtime DBSQL_SQL_ERROR message: Missing end comment)

1. 오류 발생

SAP 시작 실패!

 

2. 원인 파악

(1) 로그 확인

/usr/sap/<SID>/<Instance>/work/dev_w0 로그 확인

 

DB 연결 불가

 

오류 로그 내용

M Mon Jan 06 23:58:46 2020

M  ThInit: running on host sapehp7db01

I  MtxInit: 0 0 0

M  calling db_connect ...

B  Loading DB library 'C:\usr\sap\TE7\DVEBMGS01\exe\dbmssslib.dll' ...

B  Library 'C:\usr\sap\TE7\DVEBMGS01\exe\dbmssslib.dll' loaded

B  Version of 'C:\usr\sap\TE7\DVEBMGS01\exe\dbmssslib.dll' is "742.06", patchlevel (0.25)

C  Callback functions for dynamic profile parameter registered

C  Warning: Env(MSSQL_SERVER) [SAPEHP7MSSQL] <> Prof(dbs/mss/server) [<null>]. No value will be used.

C  Warning: Env(MSSQL_SCHEMA) [te7] <> Prof(dbs/mss/schema) [dbo]. Profile value will be used.

C  Thread ID:4344

C  Thank You for using the SLODBC-interface

C  Using dynamic link library 'C:\usr\sap\TE7\DVEBMGS01\exe\dbmssslib.dll'

C  7420 dbmssslib.dll patch info

C    SAP patchlevel  0

C    SAP patchno  28

C    Last MSSQL DBSL patchlevel 0

C    Last MSSQL DBSL patchno         25

C    Last MSSQL DBSL patchcomment ABAP runtime DBSQL_SQL_ERROR  message: Missing end comment (2087416)

C  ODBC Driver chosen: SQL Server Native Client 11.0 native

C  Network connection used from sapehp7db01 to (local) using tcp:(local)

C 

C Mon Jan 06 23:59:05 2020

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2562]

C  (10061) [08001] [Microsoft][SQL Server Native Client 11.0]TCP Provider: 대상 컴퓨터에서 연결을 거부했으므로 연결하지 못했습니다.

 

C 

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2562]

C  (0) [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 2562]

C  (10061) [08001] [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

 

(2) DB 연결 확인

R3trans -d 실행 결과 이상 없음

즉, DB에는 이상 없음

필요할 경우 SSMS(SQL Server Management Studio) 연결하여 상태 확인도 가능

 

(3) 프로파일 확인

Default Profile에 DB 관련 파라미터가 잘못 설정되어 있었음

정상적으로 수정 후 SAP 재시작

 

해결