Ok .. I know it is my mistake ...
I deleted the Analysis Server Repository database from my development server ...
Is there a way to rebuild it from the files ...
Help Me !!!!!!!!!!!!!Do you have a backup?|||Hmm ... you must be wondering what kind of DBA I am ..
Well ... it was the development server i was asked to clean up ...
And along with the database I deleted the backups too ...|||Originally posted by Enigma
Hmm ... you must be wondering what kind of DBA I am ..
Well ... it was the development server i was asked to clean up ...
And along with the database I deleted the backups too ...
Enigma
Can you clarify that the Analysis Repository was running as a SQL database? I under the impression that the repository is normally an access database which you can upgrade to SQL and if upgraded is then stored in MSDB.|||Yup .. you are right ...
However the repository can be configured to run from a SQL DB also|||Originally posted by Enigma
Yup .. you are right ...
However the repository can be configured to run from a SQL DB also
Mmm sorry Engima but I think that without backups you might be in trouble. I take it there was no tape/file backup of the backup files.|||the repository should be configured to run from a SQL DB
After installing AS you should Migrate Repository
Showing posts with label repository. Show all posts
Showing posts with label repository. Show all posts
Sunday, March 25, 2012
Thursday, March 22, 2012
Analysis Server - Incompatible repository
Hi,
We have been using MS Analysis Server with Axapta (a mid-range ERP from MS)
for quite some time. So long we were able to create/run cubes without any
problem.
But today all of a sudden we are getting the following error message -
...................................... .........
Error
Transferring cube(s)\<CUBE NAME>\Connecting to the OLAP ServerMethod
'Connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB9898D}'
returned error code 0x80040034 (<unknown>) which means: Incompatible
repository.
...................................... .........
The thing is nothing has changed from Axapta end. So my query is this -
Is there anything on AS that could cause such error message? Can someone
let me know please.
TIA,
Harish Mohanbabu
MBS Axapta - MVP
http://www.harishm.com/
Hello,
To isolate the issue, you may try to check if the issue occurs on different
clients or you could use MDX sample application on server to test.
If it is client side issue, please refer to the following article to
troubleshoot the issue:
288890 PRB: Incompatible Repository Error Message Occurs After Installation
of
http://support.microsoft.com/?id=288890
If the issue persists, you may try to unregister the DSO dll's in the
following order:
msmddo80.dll
msmddo.dll
msmdlock.dll
msmdnet.dll
msmdint.dll
Then register the above Dll's in the reverse order, starting with
msmdint.dll.
If we confirm it is a server side issue, it is more like a database
corruption, you may try to archive the current database, and then restore a
known good one on AS server to test.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...national.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Analysis Server - Incompatible repository
| thread-index: AcXxCdpBYHIh/957S2CAGRK2YCeB6A==
| X-WBNR-Posting-Host: 80.245.107.27
| From: "=?Utf-8?B?SGFyaXNoIE1vaGFuYmFidQ==?=" <Axapta@.online.nospam>
| Subject: Analysis Server - Incompatible repository
| Date: Thu, 24 Nov 2005 07:15:06 -0800
| Lines: 27
| Message-ID: <668B07C4-AE5B-47F6-BD03-682AC746E133@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.datawarehouse
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.datawarehouse:21772
| X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
|
| Hi,
|
| We have been using MS Analysis Server with Axapta (a mid-range ERP from
MS)
| for quite some time. So long we were able to create/run cubes without
any
| problem.
|
| But today all of a sudden we are getting the following error message -
|
| ...................................... ........
| Error
| Transferring cube(s)\<CUBE NAME>\Connecting to the OLAP ServerMethod
| 'Connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB9898D}'
| returned error code 0x80040034 (<unknown>) which means: Incompatible
| repository.
| ...................................... ........
|
| The thing is nothing has changed from Axapta end. So my query is this -
|
| Is there anything on AS that could cause such error message? Can someone
| let me know please.
|
| TIA,
|
| Harish Mohanbabu
| --
| MBS Axapta - MVP
| http://www.harishm.com/
|
We have been using MS Analysis Server with Axapta (a mid-range ERP from MS)
for quite some time. So long we were able to create/run cubes without any
problem.
But today all of a sudden we are getting the following error message -
...................................... .........
Error
Transferring cube(s)\<CUBE NAME>\Connecting to the OLAP ServerMethod
'Connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB9898D}'
returned error code 0x80040034 (<unknown>) which means: Incompatible
repository.
...................................... .........
The thing is nothing has changed from Axapta end. So my query is this -
Is there anything on AS that could cause such error message? Can someone
let me know please.
TIA,
Harish Mohanbabu
MBS Axapta - MVP
http://www.harishm.com/
Hello,
To isolate the issue, you may try to check if the issue occurs on different
clients or you could use MDX sample application on server to test.
If it is client side issue, please refer to the following article to
troubleshoot the issue:
288890 PRB: Incompatible Repository Error Message Occurs After Installation
of
http://support.microsoft.com/?id=288890
If the issue persists, you may try to unregister the DSO dll's in the
following order:
msmddo80.dll
msmddo.dll
msmdlock.dll
msmdnet.dll
msmdint.dll
Then register the above Dll's in the reverse order, starting with
msmdint.dll.
If we confirm it is a server side issue, it is more like a database
corruption, you may try to archive the current database, and then restore a
known good one on AS server to test.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...national.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Analysis Server - Incompatible repository
| thread-index: AcXxCdpBYHIh/957S2CAGRK2YCeB6A==
| X-WBNR-Posting-Host: 80.245.107.27
| From: "=?Utf-8?B?SGFyaXNoIE1vaGFuYmFidQ==?=" <Axapta@.online.nospam>
| Subject: Analysis Server - Incompatible repository
| Date: Thu, 24 Nov 2005 07:15:06 -0800
| Lines: 27
| Message-ID: <668B07C4-AE5B-47F6-BD03-682AC746E133@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.datawarehouse
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.datawarehouse:21772
| X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
|
| Hi,
|
| We have been using MS Analysis Server with Axapta (a mid-range ERP from
MS)
| for quite some time. So long we were able to create/run cubes without
any
| problem.
|
| But today all of a sudden we are getting the following error message -
|
| ...................................... ........
| Error
| Transferring cube(s)\<CUBE NAME>\Connecting to the OLAP ServerMethod
| 'Connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB9898D}'
| returned error code 0x80040034 (<unknown>) which means: Incompatible
| repository.
| ...................................... ........
|
| The thing is nothing has changed from Axapta end. So my query is this -
|
| Is there anything on AS that could cause such error message? Can someone
| let me know please.
|
| TIA,
|
| Harish Mohanbabu
| --
| MBS Axapta - MVP
| http://www.harishm.com/
|
Analysis Server - Incompatible repository
Hi,
We have been using MS Analysis Server with Axapta (a mid-range ERP from MS)
for quite some time. So long we were able to create/run cubes without any
problem.
But today all of a sudden we are getting the following error message -
.............................................
Error
Transferring cube(s)\<CUBE NAME>\Connecting to the OLAP Server Method
'Connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB9898D
}'
returned error code 0x80040034 (<unknown> ) which means: Incompatible
repository.
.............................................
The thing is nothing has changed from Axapta end. So my query is this -
Is there anything on AS that could cause such error message? Can someone
let me know please.
TIA,
Harish Mohanbabu
--
MBS Axapta - MVP
http://www.harishm.com/Hello,
To isolate the issue, you may try to check if the issue occurs on different
clients or you could use MDX sample application on server to test.
If it is client side issue, please refer to the following article to
troubleshoot the issue:
288890 PRB: Incompatible Repository Error Message Occurs After Installation
of
http://support.microsoft.com/?id=288890
If the issue persists, you may try to unregister the DSO dll's in the
following order:
msmddo80.dll
msmddo.dll
msmdlock.dll
msmdnet.dll
msmdint.dll
Then register the above Dll's in the reverse order, starting with
msmdint.dll.
If we confirm it is a server side issue, it is more like a database
corruption, you may try to archive the current database, and then restore a
known good one on AS server to test.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Analysis Server - Incompatible repository
| thread-index: AcXxCdpBYHIh/957S2CAGRK2YCeB6A==
| X-WBNR-Posting-Host: 80.245.107.27
| From: "examnotes" <Axapta@.online.nospam>
| Subject: Analysis Server - Incompatible repository
| Date: Thu, 24 Nov 2005 07:15:06 -0800
| Lines: 27
| Message-ID: <668B07C4-AE5B-47F6-BD03-682AC746E133@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.datawarehouse
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.datawarehouse:21772
| X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
|
| Hi,
|
| We have been using MS Analysis Server with Axapta (a mid-range ERP from
MS)
| for quite some time. So long we were able to create/run cubes without
any
| problem.
|
| But today all of a sudden we are getting the following error message -
|
| .............................................
| Error
| Transferring cube(s)\<CUBE NAME>\Connecting to the OLAP Server Method
| 'Connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB989
8D}'
| returned error code 0x80040034 (<unknown> ) which means: Incompatible
| repository.
| .............................................
|
| The thing is nothing has changed from Axapta end. So my query is this -
|
| Is there anything on AS that could cause such error message? Can someone
| let me know please.
|
| TIA,
|
| Harish Mohanbabu
| --
| MBS Axapta - MVP
| http://www.harishm.com/
|
We have been using MS Analysis Server with Axapta (a mid-range ERP from MS)
for quite some time. So long we were able to create/run cubes without any
problem.
But today all of a sudden we are getting the following error message -
.............................................
Error
Transferring cube(s)\<CUBE NAME>\Connecting to the OLAP Server Method
'Connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB9898D
}'
returned error code 0x80040034 (<unknown> ) which means: Incompatible
repository.
.............................................
The thing is nothing has changed from Axapta end. So my query is this -
Is there anything on AS that could cause such error message? Can someone
let me know please.
TIA,
Harish Mohanbabu
--
MBS Axapta - MVP
http://www.harishm.com/Hello,
To isolate the issue, you may try to check if the issue occurs on different
clients or you could use MDX sample application on server to test.
If it is client side issue, please refer to the following article to
troubleshoot the issue:
288890 PRB: Incompatible Repository Error Message Occurs After Installation
of
http://support.microsoft.com/?id=288890
If the issue persists, you may try to unregister the DSO dll's in the
following order:
msmddo80.dll
msmddo.dll
msmdlock.dll
msmdnet.dll
msmdint.dll
Then register the above Dll's in the reverse order, starting with
msmdint.dll.
If we confirm it is a server side issue, it is more like a database
corruption, you may try to archive the current database, and then restore a
known good one on AS server to test.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Analysis Server - Incompatible repository
| thread-index: AcXxCdpBYHIh/957S2CAGRK2YCeB6A==
| X-WBNR-Posting-Host: 80.245.107.27
| From: "examnotes" <Axapta@.online.nospam>
| Subject: Analysis Server - Incompatible repository
| Date: Thu, 24 Nov 2005 07:15:06 -0800
| Lines: 27
| Message-ID: <668B07C4-AE5B-47F6-BD03-682AC746E133@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.datawarehouse
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.datawarehouse:21772
| X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
|
| Hi,
|
| We have been using MS Analysis Server with Axapta (a mid-range ERP from
MS)
| for quite some time. So long we were able to create/run cubes without
any
| problem.
|
| But today all of a sudden we are getting the following error message -
|
| .............................................
| Error
| Transferring cube(s)\<CUBE NAME>\Connecting to the OLAP Server Method
| 'Connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB989
8D}'
| returned error code 0x80040034 (<unknown> ) which means: Incompatible
| repository.
| .............................................
|
| The thing is nothing has changed from Axapta end. So my query is this -
|
| Is there anything on AS that could cause such error message? Can someone
| let me know please.
|
| TIA,
|
| Harish Mohanbabu
| --
| MBS Axapta - MVP
| http://www.harishm.com/
|
Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.
While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window:
=================================================
Analysis Manager:
Cannot connect to repository.
Analysis Server: <server name>.
Error:
Provider cannot be found. It may not be properly installed.
=================================================
Can somebody help?
Thanks,
John T
Please try this:
- with Analysis Manager, right click on the server item (or the server name) and use "Edit Repository Connection String"
- there are 2 connection strings there: the local one (for the client running on the AS2000 server machine) and the remote one; from the error message, it seems that the remote one is improperly set
Adrian.
|||Adrian, I checked th connection string. It matches the connection string on my other machine from which I can connect without any issues. Any thoughts?
John T
|||my problem was that i was using jet 3.5 not 4.0 there is a solution for creating a connection string here:http://support.microsoft.com/?kbid=330244|||
Pete, A coworker of mine helped me figure this. I knew there was somethign wrong with the Jet engine on my machine but repeated attempts to fix the Jet did not seem to help. Finally we used Microsoft Access Driver (shown below) instead of the OLEDB JET
Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<servername>\MsOLAPRepository$\msmdrep.mdb
Thank you for you help.
John T
Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.
While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window:
=================================================
Analysis Manager:
Cannot connect to repository.
Analysis Server: <server name>.
Error:
Provider cannot be found. It may not be properly installed.
=================================================
Can somebody help?
Thanks,
John T
Please try this:
- with Analysis Manager, right click on the server item (or the server name) and use "Edit Repository Connection String"
- there are 2 connection strings there: the local one (for the client running on the AS2000 server machine) and the remote one; from the error message, it seems that the remote one is improperly set
Adrian.
|||Adrian, I checked th connection string. It matches the connection string on my other machine from which I can connect without any issues. Any thoughts?
John T
|||my problem was that i was using jet 3.5 not 4.0 there is a solution for creating a connection string here:http://support.microsoft.com/?kbid=330244|||
Pete, A coworker of mine helped me figure this. I knew there was somethign wrong with the Jet engine on my machine but repeated attempts to fix the Jet did not seem to help. Finally we used Microsoft Access Driver (shown below) instead of the OLEDB JET
Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<servername>\MsOLAPRepository$\msmdrep.mdb
Thank you for you help.
John T
Subscribe to:
Posts (Atom)