RM CC4.3 Database Version

[superaz300]

Hello Guys,

 

Can somebody please tell me what version of Postgres should be running on a CC4.3 server (Windows Server 2008 R2) I think I may have the wrong version.

 

Thanks for reading,

 

James

[foofighterjim]

8.3 here.

[superaz300]

Hi,

 

Thank you for confirming, well to be honest I didn't want you to say that because I have that version and I am having allot of issues in terms on RM Comms and Security not installing.

 

Thanks,

 

James

[truebluesteve]

Hi,

 

Thank you for confirming, well to be honest I didn't want you to say that because I have that version and I am having allot of issues in terms on RM Comms and Security not installing.

 

Thanks,

 

James

 

Seem this issue before when installing an update and I had to stop another service to get it to install,. Can't remember which off the top of my head but its in a call note somewhere

[superaz300]

I just get this in the log file

 

Main

 

13/05/2015 16:04:36:450 1 Parameters: args = System.String[]

 

13/05/2015 16:04:36:466 1 Path=C:\Program Files (x86)\RM\Connect\Comms, Unregister=False, Silent=True, Services=True, Commands=False

 

13/05/2015 16:04:36:965 1 Successfully connected to database: resuming service loading

 

13/05/2015 16:04:37:028 1 \WaitForDBToStart

 

13/05/2015 16:04:37:028 1 Successfully connected to database: resuming service loading

 

13/05/2015 16:04:37:028 1 /WaitForDBToStart

 

13/05/2015 16:04:37:636 1 \MachineNameDAO: Insert

 

13/05/2015 16:04:37:636 1 Inserting machine name BRF-SR-01 into the database

 

13/05/2015 16:04:37:932 1 /MachineNameDAO: Insert

 

13/05/2015 16:04:37:948 1 \Started

 

13/05/2015 16:04:37:948 1 Failed to open local service host event - No handle of the given name exists.

 

13/05/2015 16:04:37:948 1 /Started

 

13/05/2015 16:04:37:948 1 \Scopes:Install

 

13/05/2015 16:04:37:948 1 \Scopes:GetIsScopeDataAvailable

 

13/05/2015 16:04:37:948 1 Checking whether SiteManager.Scope table contains any records

 

13/05/2015 16:04:38:042 1 /Scopes:GetIsScopeDataAvailable

 

13/05/2015 16:04:38:042 1 !ERROR : 42P01 : relation "SiteManager.Scope" does not exist

 

13/05/2015 16:04:38:042 1 !RM.Networks.Comms.Data.DalDatabaseException: ERROR : 42P01 : relation "SiteManager.Scope" does not exist ---> RM.Networks.Data.PostgreSQL.Provider.PgException: ERROR : 42P01 : relation "SiteManager.Scope" does not exist

at RM.Networks.Data.PostgreSQL.Provider.PgCommand.ExecuteScalar()

at RM.Networks.Comms.Data.ProviderBaseClasses.DalDbCommandBase`6.ExecuteScalar()

at RM.Networks.Comms.Data.DalAdminCommand.ExecuteScalar()

--- End of inner exception stack trace ---

at RM.Networks.Comms.Data.DalAdminCommand.ExecuteScalar()

at RM.Networks.Comms.Installer.Scopes.GetIsScopeDataAvailable()

at RM.Networks.Comms.Installer.Scopes.Install(Boolean force)

 

 

13/05/2015 16:04:38:229 1 /Scopes:Install

 

13/05/2015 16:04:38:229 1 /Main

 

13/05/2015 16:04:38:322 1 \Report

 

13/05/2015 16:04:38:322 1 !Unhandled exception:ERROR : 42P01 : relation "SiteManager.Scope" does not exist.

 

13/05/2015 16:04:38:322 1 /Report

 

13/05/2015 16:04:38:322 1 \Main

 

13/05/2015 16:04:38:322 1 (Un)installation complete

 

13/05/2015 16:04:38:338 1 /Main

 

 

Application log closed at 13/05/2015 16:04:38:338

[AXE]

Looks like the database is either empty, or doesn't contain an important table.

Is it a new server install?

Is there a /forcescope switch in the installer?

[superaz300]

Hello AXE,

 

I have just PM you.

 

Thanks

[superaz300]

In the DB, their is no Scopes table under Site Manager, I though Comms installed this to be honest.

[Edu-IT]

There is a Postgres version update in the works.