Skip to Content
0

streamingserver not initialized

Aug 31, 2017 at 12:37 AM

137

avatar image
Former Member

I am unable to get streamingserver to initialiaze. I have run. . .

ALTER SYSTEM INITIALIZE SERVICE 'streamingserver' WITH CREDENTIAL TYPE 'PASSWORD'USING 'xxxxxxxxx'

Resulting in. . .

SAP DBTech JDBC: [331]: user name already exists: SYS_STREAMING: line 1 col 13 (at pos 12)

I have also tried to uninitialize by running. . .

ALTER SYSTEM UNINITIALIZE SERVICE 'streamingserver' drop cascade

Resulting in. . .

SAP DBTech JDBC: [403]: internal error: No Streaming Server available to be uninitialized for tenant database SDS

I am a bit confused. It says the user already exists but there is no steaming server avaialable. Any thoughts?

10 |10000 characters needed characters left characters exceeded

We need some more details:

1) Are you setting up Streaming with HXE or a full HANA instance?

2) What version are you using?

3) When executing the ALTER SYSTEM INITIALIZE SERVICE... statement are you connected to the tenant database or the system database?

4) Are you connected as the SYSTEM user?

5) Had you previously succesfully executed the "ALTER DATABASE <database_name> ADD 'streamingserver' " from the system database?

Provisioning the Streaming Analytics Service to a Tenant Database

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers