Procedure 'launchremotecmd' not found

[parul]

HI,

While creating a database i get an error saying "E_US0965 Procedure 'launchremotecmd' not found."
What could be the reason? I am connecting to the database with the same user I have used to install Ingress. Is there something which I might have missed during the installation?

Thanks
Parul

[fba]

I assume you are trying to create a database using the visual tools?
The database procedure launchremotecmd should exist in the imadb database.
Check out the rmcmdgen command on http://docs.actian.com/ingres/10.0/c...mmand-catalogs.

[parul]

Thanks Frederic. I tried executing this command rmcmdgen but it says

Create rmcmd objects failed:
E_US100D line 1, Syntax error on '.'. The correct syntax is: GRAN

Please help with this.

Thanks
Parul

[parul]

Adding some more information(just in case it helps), when i try to start remote commands from Ingres Visual Manager, it is not able to start the command and says in the event logs that "Cannot access RMCMD objects. The sql error code was -30100."
Is this somewhere related to the problem of not able to launchremotecmd procedure not found?

[kschendel]

What is the user name you installed Ingres with?

[parul]

I assume it is under local system account. It did not ask me to choose any user name. I am running express installation.

Thanks

[bilgihan]

How is you local system admin called?

[parul]

I have installed it now with my windows user account but it still says cannot run launchremotecmd.This user has all the admin privileges.
Why running rmcdgen command gives me the following error?

Create rmcmd objects failed:
E_US100D line 1, Syntax error on '.'. The correct syntax is: GRAN

[bilgihan]

Hello Parul,

I still don't see the user name which is being used for this.
Of course you can validate your self the username if it is being support.
http://docs.actian.com/ingres/9.2/in...and-user-names

Thanks - Bilgihan

[parul]

parul.sharma is the user name and blrpn0m79111.afcorp.afn.com is the computer name and C:\Program Files\Ingres\IngresII is the directory where I have installed. These seem to be Valid Computer, Directory, and User Name?