Error:
while download PLI csv file from account PBS it shows an error message as "Sub query returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= of when the sub query is used as an expression"
SOLUTION:
1. Once u run the exe, u will have to enter server name and then click on Connect button. Now in the next window, if u r getting “Delete Button” at the end and the records of the policies for which same loan account number is allotted and whose active status ( 0 or 1, 0 means dead and 1 means live ) is also given, u will have to select all the unwanted policies for which same loan account number is allotted, no matter whether the active status is 0 or 1.
Don't select the policy with correct loan account number and active status as 1. Then click on Delete button.
It will delete all those unwanted policies which were raising the error.
2. After connecting to server, if u r getting the “UPDATE BUTTON” and the records of the policies in which, for the same policy number, two live LOAN ACCOUNT NUMBERS are allotted, then u will have to make the wrong LOAN ACCOUNT NUMBER as dead. For making it dead, u will select that particular record of the policies and click on “UPDATE BUTTON.”
3. If u r not getting any records, it means that everything is all right in Loan Repayment
4.download the exl PLIMaster_duplicate.exl and run through script tool.
Download
Courtesy : http://potools.blogspot.in
0 comments:
Post a Comment