No language handler installed

[Former Member]

Hi,

Recently I installed ase16 and when I am trying to issue q command to an open server application, am getting this no language handler error.

But when I try the same with my actual prod setup it works perfectly.

I there anything I am going wrong here ?

Any reference on this would also be of great help.

[former_member188958]

How is ASE involved in this scenario?

This "no language handler installed" message is most commonly seen when someone connects directly to the Backup Server with isql and issues some command like "dump database". In that case the message is expected because Backup Server is an Open Server application and indeed does not have a language handler installed, it communicates directly with ASE using RPC calls only.

Sounds like your application might be connecting to the Backup Server instead of your Open Server application, perhaps some mixup on port numbers in the interfaces file? 

-bret

[Former Member]

Thanks for the reply Bret.

To be more specific, I have a procedure which does an RPC call to an Open Server Application which returns a character value.

When I execute this procedure I am getting this "no language handler" error and when I executed the RPC call alone (not from procedure), I am getting the correct output.

refer the attachment for the error message,

the RPC call in the procedure is,

EXEC @ret = OS_APP...func_proc "A", "B", @op OUTPUT

when i execute the above RPC call it executes well but it fails when i execute from the procedure.

Could you please help me with this error.

Any reference on this would also be of great help.

[former_member188958]

Just a guess, but try putting a "set cis rpc handling off" command before the rpc call and see if that makes a difference.  If not, try "on".

-bret

[former_member188958]

After a little research... if you run sp_helpserver, what "server class" does your open server application show up as?

If it doesn't have a language handler, I think it should have been added as an RPCServer; I suspect it may have been added as an ASEnterprise server.   Note that if the server class value is null, the remote server is treated as an RPCServer.

-bret

[Former Member]

Hi Bret,

Thanks for the reply.

I tried with both cis_rpc_handling values but it is still the same. I am still getting the same error "No language handler installed."

I checked the server class and it is 7 (ASEnterprise), this value is same as that of the prod setup.

The only diff that i could find when i do a sp_helpserver is,

     The status in the local setup is "no timeouts, no net password encryption, writable , enable login redirection"

     While that in the prod setup is "no timeouts, no net password encryption, writable , rpc security model A"

Also, the new local setup of mine is ASE Linux 16.0 and the prod setup is Solaris 15.0 and the OS App is also of Solaris..

So would there be any dependency on platforms, because when I checked the application log it has the message "Changed language setting to 'us_english'" and after that i don't see any of the other debug statements.

I have checked the locale.dat file and both of them have the same locale [ locale = default, us_english, iso_1 ]

does it also depend on the platform or is it a problem with the language handler ?

Also you said, "after a little research you found out...", how was it that you concluded that this could be a problem of the server class..this could help me with any of my future problems for trouble shooting.

Thanks for the help

[Former Member]

Hi Bret,

Any update on this ?