cancel
Showing results for 
Search instead for 
Did you mean: 

streamingserver not initialized

Former Member
0 Kudos

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?

RobertWaywell
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Accepted Solutions (0)

Answers (0)