invalid server

[Former Member]

Hi,

i excuted SQL query in BL. it displays as invalid server was used. how can i overcome this problem

- senthil

[Former Member]

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?

[Former Member]

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

[Former Member]

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