Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Gergo Koppany (gergokoppany)
Saltech Consulting

Saltech Consulting
HU
gergokoppany Member since 2016 1 post
Saltech Consulting
Posted: May 24, 2022
Last activity: May 25, 2022
Posted: 24 May 2022 8:08 EDT
Last activity: 25 May 2022 12:58 EDT
Closed

TDS protocol stream invalid

We get the following exception:

 

Show More

We get the following exception:

 

2022-05-24 06:53:23,531 [       CORPSRVPEGA30] [  STANDARD] [                    ] [                    ] (l.access.RDBPageResultPackager) ERROR   - There was a database problem when performing an RDBExecute 
com.pega.pegarules.pub.database.ConnectionException: Database-General	There was a database problem when performing an RDBExecute	0	08S01	The TDS protocol stream is not valid. 
DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid. 
 | SQL Code: 0 | SQL State: 08S01 
 
	at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:379) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:364) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.RDBPageResultPackager.handleResultSet(RDBPageResultPackager.java:708) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.RDBPageResultPackager.packageDataStoreResults(RDBPageResultPackager.java:328) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.RDBPageResultPackager.packageResults(RDBPageResultPackager.java:462) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:420) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:190) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:126) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:73) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:3169) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:3149) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.generation.internal.library.LibraryMetadataCacheDAO$LibFunctionProviderImpl.getAllRUFsForLib(LibraryMetadataCacheDAO.java:144) ~[prprivate-generation.jar:?] 
	at com.pega.pegarules.generation.internal.library.LibraryMetadataCacheDAO.populateLibraryDefs(LibraryMetadataCacheDAO.java:194) ~[prprivate-generation.jar:?] 
	at com.pega.pegarules.generation.internal.library.LibraryMetadataCacheDAO.createLibraryMetadataFromDB(LibraryMetadataCacheDAO.java:211) ~[prprivate-generation.jar:?] 
	at com.pega.pegarules.generation.internal.library.LibraryMetadataCache.populateFromDb(LibraryMetadataCache.java:684) ~[prprivate-generation.jar:?] 
	at com.pega.pegarules.generation.internal.library.LibraryMetadataCache.populateFromDb(LibraryMetadataCache.java:675) ~[prprivate-generation.jar:?] 
	at com.pega.pegarules.generation.internal.library.LibraryFunctionUtilityImpl.populateLibraryMetadataCacheFromDb(LibraryFunctionUtilityImpl.java:3550) ~[prprivate-generation.jar:?] 
	at com.pega.pegarules.session.internal.mgmt.PRNodeImpl.handleExtraction(PRNodeImpl.java:1660) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.mgmt.PREnvironment.finishInit(PREnvironment.java:599) ~[prprivate-session.jar:?] 
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_251] 
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_251] 
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_251] 
	at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_251] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1408) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1140) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:960) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:408) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.getThreadAndInitialize(PRSessionProviderImpl.java:2185) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineStartup.initEngine(EngineStartup.java:679) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._initEngine_privact(EngineImpl.java:180) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.doStartup(EngineImpl.java:152) ~[prprivate-session.jar:?] 
	at com.pega.pegarules.web.servlet.WebAppLifeCycleListener._contextInitialized_privact(WebAppLifeCycleListener.java:210) ~[prwebj2ee.jar:?] 
	at com.pega.pegarules.web.servlet.AbstractLifeCycleListener._contextInitialized_privact(AbstractLifeCycleListener.java:145) ~[prwebj2ee.jar:?] 
	at com.pega.pegarules.web.servlet.AbstractLifeCycleListener.contextInitialized(AbstractLifeCycleListener.java:76) ~[prwebj2ee.jar:?] 
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_251] 
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_251] 
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_251] 
	at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_251] 
	at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:385) ~[prbootstrap-8.4.1-359.jar:8.4.1-359] 
	at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:427) ~[prbootstrap-8.4.1-359.jar:8.4.1-359] 
	at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225) ~[prbootstrap-api-8.4.1-359.jar:8.4.1-359] 
	at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:274) ~[prbootstrap-api-8.4.1-359.jar:8.4.1-359] 
	at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextInitialized(WebAppLifeCycleListenerBoot.java:92) ~[prbootstrap-api-8.4.1-359.jar:8.4.1-359] 
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4678) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5139) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1133) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1866) ~[catalina.jar:9.0.37] 
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) ~[?:1.8.0_251] 
	at java.util.concurrent.FutureTask.run(Unknown Source) ~[?:1.8.0_251] 
	at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) ~[tomcat-util.jar:9.0.37] 
	at java.util.concurrent.AbstractExecutorService.submit(Unknown Source) ~[?:1.8.0_251] 
	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1045) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:429) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374) ~[catalina.jar:9.0.37] 
	at java.util.concurrent.FutureTask.run(Unknown Source) ~[?:1.8.0_251] 
	at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) ~[tomcat-util.jar:9.0.37] 
	at java.util.concurrent.AbstractExecutorService.submit(Unknown Source) ~[?:1.8.0_251] 
	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[catalina.jar:9.0.37] 
	at org.apache.catalina.startup.Catalina.start(Catalina.java:738) ~[catalina.jar:9.0.37] 
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_251] 
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_251] 
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_251] 
	at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_251] 
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:342) ~[bootstrap.jar:9.0.37] 
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473) ~[bootstrap.jar:9.0.37] 
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid. 
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2998) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2987) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.throwInvalidTDS(SQLServerConnection.java:2970) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.TDSReader.throwInvalidTDS(IOBuffer.java:6357) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6475) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7612) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet$CursorFetchCommand.doExecute(SQLServerResultSet.java:5480) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7225) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3053) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet.doServerFetch(SQLServerResultSet.java:5517) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1050) ~[mssql-jdbc-8.2.2.jre8.jar:?] 
	at org.apache.tomcat.dbcp.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1159) ~[tomcat-dbcp-9.0.37.jar:9.0.37] 
	at org.apache.tomcat.dbcp.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1159) ~[tomcat-dbcp-9.0.37.jar:9.0.37] 
	at com.pega.pegarules.data.internal.store.rdbms.DatabaseResultSetForwardOnly.next(DatabaseResultSetForwardOnly.java:124) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.store.rdbms.ResultPageIteratorImpl.<init>(ResultPageIteratorImpl.java:404) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.store.DataStoreResultPageIterator.getResultPageIter(DataStoreResultPageIterator.java:53) ~[prprivate-data.jar:?] 
	at com.pega.pegarules.data.internal.access.RDBPageResultPackager.handleResultSet(RDBPageResultPackager.java:615) ~[prprivate-data.jar:?] 
	... 81 more 

 

 

Pega 8.4, on MSSQL 13 with JDBC driver Proprietary information hidden

Did anyone face a similar issue?

Show Less
To see attachments, please log in.
Pega Platform
System Administration
Lead System Architect

  • Gergo Koppany
Posted: 2 years ago
Posted: 24 May 2022 14:36 EDT
Phil Shannon (PhilipShannon)
PEGA
Principal Software Engineer, EIS
Pegasystems Inc.
US

@gergokoppany Looks like this could be related to the jdbc driver version 8.2.2

A couple of years back a similar issue (not exact match) was resolved by using an older jdbc driver version. The TDS protocol stream is not valid. Unexpected token unknown token (0xA3) · Issue #1355 · microsoft/mssql-jdbc (github.com)

I would probably try a newer jdbc driver version like mssql-jdbc-10.2.0.jre8.jar, before going back to older version 6.4

 

To see attachments, please log in.
Posted: 2 years ago
Posted: 25 May 2022 12:58 EDT
Gergo Koppany (gergokoppany)
Saltech Consulting

Saltech Consulting
HU

@PhilipShannon thanks a lot for the reply.

 

According to your message, I tried with 10.2, 8.4, 8.2, 7.4 and even 6.4 but all with the same result unfortunately, I can not get rid of this message. Basic platform features are not working due to this as some queries fail to load rules from the DB due to this exception.

To see attachments, please log in.

Related content:

Question

Invalid configuration. Undefined stream provider end point.

Question Solved

Function pr_read_from_stream return invalid of alphabet position .

Question

Queue processor stream are duplicating reprocessing of kafka stream at retention

Question

718 No suitable driver found for jdbc:sybase:Tds issue

Question

Invalid clipboard stream detected in module PegaArchiveException.RuleArchiveLoader. Reason: importContents(PegaArchive)

Question

Pega server protocol mismatch issue

Question

PEGA 8.5.2 - Node Classification & Invalid configuration. Undefined stream provider end point

Question

Stream Node ?

Question Solved

Invalid clipboard stream detected in module PegaArchiveException.RuleArchiveLoader

Question

Invalid clipboard stream detected in module StorageStreamCommon.create(byte []). Reason: Invalid signature found in stream. Stream length = XXXXXXX; signature: @å; compressed = false

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice