Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Attention: The Community will be in read-only mode on 12/14/2017 from 12:00 am pacific to 11:30 am.

During this time you will only be able to see content. Other interactions such as posting, replying to questions, or marking content as helpful will be disabled for few hours.

We apologize for the inconvenience while we perform important updates to the Community.

New Member

End Of Sale/End Of Life Report Fails in LMS

Hi all,

When I execute this report the next error appears

"Unable to get data from Cisco.com. Check Cisco.com connectivity. Try again later"

Others reports that it needs Cisco.com credentials works fine.

I attach doc file with screenshots

Any idea?

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Cisco Employee

Re: End Of Sale/End Of Life Report Fails in LMS

This problem could be due to a variety of bugs. The most likely candidate is CSCsr78184. There is a patch available for this by contacting the TAC.

Re: End Of Sale/End Of Life Report Fails in LMS

It seems you are typing the SQL statement together with curly brackets or the single quotes into the SQL statement field of the dbreader interface. You should only type the following SQL statement itself into the box:

ALTER TABLE ..... VARCHAR(255)

11 REPLIES
Cisco Employee

Re: End Of Sale/End Of Life Report Fails in LMS

This problem could be due to a variety of bugs. The most likely candidate is CSCsr78184. There is a patch available for this by contacting the TAC.

New Member

Re: End Of Sale/End Of Life Report Fails in LMS

thanks

New Member

Re: End Of Sale/End Of Life Report Fails in LMS

From TAC cisco, They tell me the next one:

As a workaround:

“Modifying the EOS_EOL_CARD table with the following query (i.e. using dbreader) \fixes the problem:-

{ ALTER TABLE EOS_EOL_CARD MODIFY BULLETIN_NUMBER VARCHAR(255) } “

I have tried to access BD using dbreader tool but it request user/pass that I haven't got.

What is default user/pass?

LMS 3.0

Thanks

What is

Re: End Of Sale/End Of Life Report Fails in LMS

I wonder if there is a patch available that will do the required steps for you because doing any changes to the database contains some risks. So, first I would asks TAC if they have a patch.

The user is 'DBA' (without quotes) but there is no default password. If you did a custom installation of LMS you have entered the password during the installation; If you do not know the password you can change the password with the following steps: shut down daemon manager and run dbpasswd.pl.

on windows

"NMSROOT\bin\perl.exe" "NMSROOT\bin\dbpasswd.pl" dsn=rmeng

on solaris:

NMSROOT/bin/perl NMSROOT/bin/dbpasswd.pl dsn=rmeng

replace NMSROOT with your installation path (e.g. on windows: C:\Program Files\CSCOpx)

New Member

Re: End Of Sale/End Of Life Report Fails in LMS

Thanks mermel.

I need procedure for connect to DB on solaris. On windows, I can use dbreader but on solaris I don't know how to do it. Can you help me please?

Re: End Of Sale/End Of Life Report Fails in LMS

The dbreader interface is platform independent and you can use dbreader on solaris as well. Login to LMS as an admin and change the path to the dbreader interface. The user for the RME database (rmeng) is 'DBA'.

New Member

Re: End Of Sale/End Of Life Report Fails in LMS

Thanks again mermel

Re: End Of Sale/End Of Life Report Fails in LMS

I am glad if I could help you!

New Member

Re: End Of Sale/End Of Life Report Fails in LMS

I have other problem when I try execute this query the next error appears:

SQL Statement:

{ ALTER TABLE EOS_EOL_CARD MODIFY BULLETIN_NUMBER VARCHAR(255) }

________________________________________

*** Error ***

Syntax error near ' ALTER TABLE EOS_EOL_CARD MODIFY BULLETIN_NUMBER VARCHAR(255) ' on line 1 (DBD: prepare failed)

Why?

Best Regards, Jose

Re: End Of Sale/End Of Life Report Fails in LMS

It seems you are typing the SQL statement together with curly brackets or the single quotes into the SQL statement field of the dbreader interface. You should only type the following SQL statement itself into the box:

ALTER TABLE ..... VARCHAR(255)

New Member

Re: End Of Sale/End Of Life Report Fails in LMS

thanks it works

219
Views
14
Helpful
11
Replies
CreatePlease to create content