on 05-08-2007 7:32 AM
Hi,
i excuted SQL query in BL. it displays as invalid server was used. how can i overcome this problem
- senthil
Did you specify a Query Template in the SQL Action block in Business Logic? Is there a Data server defined in the SQL Query Template?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Senthil,
This may be due to improper server configuration in data servers.
Check whether the server is up using Query Analyser and then check status in xMII data servers
Regards,
Ajitha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Senthil,
Just try to execute the SQL Query from the Query Wizard first.
The query is probably refering to a server which is wrong or has a different name.
If that gives you the right output, just check if the Query mapping is done right in the BLS Editor.
Regards,
Arijeet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.