I am executing a sql query which will update the local table and upon update a trigger will fire to update the remote SQL server db table using DBlink.

Code:
SQL> update ps_len_tmp set nd_rank_title = 'COL' where emplid = '0028379';
update ps_len_tmp set nd_rank_title = 'COL' where emplid = '0028379'
*
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL]
ORA-02063: preceding 2 lines from TG4MSQL
ORA-06512: at "ADM.LENINSERT", line 6
ORA-04088: error during execution of trigger 'ADM.LENINSERT'
> DBlink is working
> ODBC connection is fine
> trigger is valid and working

application guys point this to db related error
where to start trouble shoot?