It is currently 17 Oct 2018 3:04


Post new topic  Reply to topic  [ 8 posts ] 
Author Message
 Post subject: Chainview 3.0
PostPosted: 07 Nov 2007 3:51 
Offline
Nouveau
Nouveau
User avatar

Joined: 05 Apr 2007 12:00
Posts: 3
J'ai installé Chainview sur un server W2003.
Lorsque je lance l'url jobtient ces messages.

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Oracle][ODBC][Ora]ORA-00936: missing expression , SQL state S1000 in SQLExecDirect in D:\Program Files\Chainview\chainview.php on line 300

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in D:\Program Files\Chainview\chainview.php on line 302

Nb j'ai configuré un System Data Source avec client oracle 9I et mis la config suivante dans chainview

boussens|CTM620DEV|||ctrlmdev|controlm|620
D|Development|EM620DEV|||ecs|ecspass|620

******************************************************************

I installed Chainview on a server W2003.
When I run the url I get these messages

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Oracle][ODBC][Ora]ORA-00936: missing expression , SQL state S1000 in SQLExecDirect in D:\Program Files\Chainview\chainview.php on line 300

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in D:\Program Files\Chainview\chainview.php on line 302

No. I configured a System Data Source client with Oracle 9I and made the following config in chainview

boussens|CTM620DEV|||ctrlmdev|controlm|620
D|Development|EM620DEV|||ecs|ecspass|620


Top
   
 Post subject:
PostPosted: 07 Nov 2007 5:46 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 716
Location: PARIS
Hi

Concerning Chainview parameters, everything seems ok.

So did test with another client or with odbc to access correctly to your database with ODBC.

This message arrive when you have a connection issue.


Top
   
 Post subject:
PostPosted: 08 Nov 2007 8:44 
Offline
Nouveau
Nouveau
User avatar

Joined: 05 Apr 2007 12:00
Posts: 3
It seems that the word %%rowcount in the select is not accepted by Oracle.
I execute the same select under sqlplus and I had the same error.


Top
   
 Post subject:
PostPosted: 08 Nov 2007 11:36 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 716
Location: PARIS
Hi

It's true. so I modified the script without @@runcount not necessary for chainview.

You can download the modified version ChainView 3.10.

It should run correctly.


Top
   
 Post subject:
PostPosted: 08 Nov 2007 3:36 
Offline
Nouveau
Nouveau
User avatar

Joined: 05 Apr 2007 12:00
Posts: 3
I had made this update myself and It seems that you have another little thing to modify :
the string dbo. before the name of the table generate an oracle error. I think it's caused by the fact that we are in "Existing " installation and the user is not "system" in oracle.
I had suppress it and it works fine.

An other question :
Do you have think to adapt Genalarm and Planview for Oracle ?

Thanks.


Top
   
 Post subject:
PostPosted: 08 Nov 2007 4:54 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 716
Location: PARIS
Ok

Thanks for your feedback.
I tested with an oracle version.
I'm not very happy. I need to work on it.

So, concerning Ganalarm and Planview, not for the moment.
I need to developp an Oracle version. I hope very quickly too.


Top
   
 Post subject:
PostPosted: 19 Oct 2010 11:34 
Offline
Nouveau
Nouveau
User avatar

Joined: 16 Jul 2010 12:00
Posts: 13
fyot wrote:
Hi

It's true. so I modified the script without @@runcount not necessary for chainview.

You can download the modified version ChainView 3.10.

It should run correctly.


Hi,
I don't know if I'm alone with this issue but the link doesn't work for me.
I can't find the file to download and i'm redirected on the home page.


Top
   
 Post subject:
PostPosted: 19 Oct 2010 11:54 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 716
Location: PARIS
Hi

Sorry but Chainview is not still downloadable.
That product now is replaced by APS Manager Console, sold by APS Enterprise.

Click on the advertisement link existing in the Home Page, to obtain more details.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 8 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved