Page 2 of 2

Posted: Sun Jan 25, 2009 1:35 pm
by ray.wurlod

Code: Select all

SELECT &SAVEDLISTS& WITH @ID LIKE "&&..."
DELETE &SAVEDLISTS&
The second command will prompt you to delete with active Select List. Answer "Yes" to this question.

Posted: Mon Jan 26, 2009 4:12 pm
by sia_999
as per your instructions we have delete the savedlists, but still it gave same Read operation faile

>SELECT &SAVEDLISTS& WITH @ID LIKE "&&..."

27 record(s) selected to SELECT list #0.
>>
>>DELETE &SAVEDLISTS&

You have an active SELECT list.
Do you wish to DELETE the records previously SELECTed?
The first record ID = "&&S.dsadm.12".
Enter Y or N: y

27 records DELETEd.
>LOGTO EDWPROD
Read operation failure. >

Posted: Mon Jan 26, 2009 4:52 pm
by sia_999
as per your instructions we have delete the savedlists, but still it gave same Read operation faile

>SELECT &SAVEDLISTS& WITH @ID LIKE "&&..."

27 record(s) selected to SELECT list #0.
>>
>>DELETE &SAVEDLISTS&

You have an active SELECT list.
Do you wish to DELETE the records previously SELECTed?
The first record ID = "&&S.dsadm.12".
Enter Y or N: y

27 records DELETEd.
>LOGTO EDWPROD
Read operation failure. >

Posted: Tue Jan 27, 2009 3:21 am
by ray.wurlod
What happened to Sunoj? Now need to think about this, meanwhile what does your official support provider have to say?

Posted: Tue Jan 27, 2009 3:48 am
by sia_999
Sunoj is busy with management work, here in middle east we have official support with IBM-SBM but we do not get any support from them.

Posted: Tue Jan 27, 2009 5:23 pm
by ray.wurlod
If you are paying for official support then you have a strong moral argument (and probably a legal argument as well) to demand that support.

Posted: Fri Feb 06, 2009 9:26 am
by sia_999
I am glad to update you that , the Read operation failure has fixed by doing the below steps.
fixtool -fix -file UV_SCHEMA
Filename: UV_SCHEMA

Start Diagnostics.
0 Errors found in physical structure.
1 Errors found in file header.
3 Errors found in file groups.
2 Other errors found in file.

5 records processed.

6 Errors on file.

Start Fixing.

An error has occurred when running.

Error: An incorrect group number has been specified
2 Errors fixed.

Fixtool Completed.

Thanks Ray for your usual support.

Posted: Fri Feb 06, 2009 2:45 pm
by ray.wurlod
Glad you found it. I was next going to suggest fixtool on UV.ACCOUNT, and only after that on the SQL Catalog tables.

Read Operation Failure

Posted: Sat Feb 07, 2009 12:38 am
by Sunoj
Thank you Ray for your support. We were able to solve the problem.