MSP 2007 Cube

[Brian]

Hi,

I'm trying to build an OLAP Cube in MSP Server 2007 beta (resting on SQL
Server 2005 and using Analysis Services 2005). I have tried about 6 times or
so and am consistently getting this error.

===== Process Completed =====
[11/8/2006 12:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Query (1, 10) Parser: The
syntax for ',' is incorrect.

Does anybody know what this means? Even if the solution is not readily
available, if somebody can let me know what the error message is telling me,
that would be much appreciated.

I posted this question in the MSP Server forum, but I think that a developer
skill set may be more appropriate to answer.

Thanks,
Brian

 

[Sumit]

Hey Brian,
I was finally able to resolve this issue, just follow the steps as under:

The solution to this is to get a copy of the msmdrep.mdb file from a AS2000
installation folder(should be available in the Bin directory) and copy it
over onto AS2005 installation folder of the DBA's choice.( Possibly a New
folder created in the MSSQL.n folder, n is the number for OLAP directory.
Generally this is 2).

After this is done please follow the following procedure.

START-> PROGRAMS->SQL SERVER2005-> SQL MANAGEMENT STUDIO

a) Once the Management Studio Opens it shows Connecting Options.
b) Select Analysis Engine and click connect.
c) On the Object Explorer on the Right the connection to the server is shown.
d) Right click on the server and select Properties.
e) A window opens with the options on the left showing General... Security.
By default the General properties are shown on the right
f) At the end of the window there is a check box saying SHOW ADVANCED or
ADVANCED Properties.
g) Please check the check box.
h) there will many other options added now to the General properties to the
existing ones.
i) On scrolling down you see DSO and then there are 4 fields, one after the
other saying DSO\Repository Connection String etc...

the following options are available for DSO.

RemoteRepositoryConnectionString
RepositoryConnectionString
RemoteLocksDirectory
LocksDirectory

Create a folder in the same folder where the .MDB file was placed and name
it as LocksDirectory. This folder logs any locks that happen when trying to
process a cube, if in instance 2 people try to process the cube at the same
time.
RepositoryConnectionString: Place the path of the .mdb file in this. Or you
can browse and select the .MDB file. Please do not forget to test the
connection before accepting this.

LocksDirectory: This folder is used to log any locks if they are come
across.

RemoteRepositoryConnectionString: For using applications across a network
which need access to the cube definitions this is necessary. the folder
created for RepositoryConnectionString can be shared and the path as
\\machinename\\sharedfolder\file name against this.

RemoteLocksDirectory: Similar to the Remote Repository Connection string
this needs to be done.

This gives access of the cube definitions to other applications which try
using AS2005 cubes.

Hope this helps.

Regards,
Sumit

Hi,

I'm trying to build an OLAP Cube in MSP Server 2007 beta (resting on SQL
Server 2005 and using Analysis Services 2005). I have tried about 6 times or
so and am consistently getting this error.

===== Process Completed =====
[11/8/2006 12:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Query (1, 10) Parser: The
syntax for ',' is incorrect.

Does anybody know what this means? Even if the solution is not readily
available, if somebody can let me know what the error message is telling me,
that would be much appreciated.

I posted this question in the MSP Server forum, but I think that a developer
skill set may be more appropriate to answer.

Thanks,
Brian

 

[Brian]

Thanks for sharing this, Sumit!

Hey Brian,
I was finally able to resolve this issue, just follow the steps as under:

The solution to this is to get a copy of the msmdrep.mdb file from a AS2000
installation folder(should be available in the Bin directory) and copy it
over onto AS2005 installation folder of the DBA's choice.( Possibly a New
folder created in the MSSQL.n folder, n is the number for OLAP directory.
Generally this is 2).

After this is done please follow the following procedure.

START-> PROGRAMS->SQL SERVER2005-> SQL MANAGEMENT STUDIO

a) Once the Management Studio Opens it shows Connecting Options.
b) Select Analysis Engine and click connect.
c) On the Object Explorer on the Right the connection to the server is shown.
d) Right click on the server and select Properties.
e) A window opens with the options on the left showing General... Security.
By default the General properties are shown on the right
f) At the end of the window there is a check box saying SHOW ADVANCED or
ADVANCED Properties.
g) Please check the check box.
h) there will many other options added now to the General properties to the
existing ones.
i) On scrolling down you see DSO and then there are 4 fields, one after the
other saying DSO\Repository Connection String etc...

the following options are available for DSO.

RemoteRepositoryConnectionString
RepositoryConnectionString
RemoteLocksDirectory
LocksDirectory

Create a folder in the same folder where the .MDB file was placed and name
it as LocksDirectory. This folder logs any locks that happen when trying to
process a cube, if in instance 2 people try to process the cube at the same
time.
RepositoryConnectionString: Place the path of the .mdb file in this. Or you
can browse and select the .MDB file. Please do not forget to test the
connection before accepting this.

LocksDirectory: This folder is used to log any locks if they are come
across.

RemoteRepositoryConnectionString: For using applications across a network
which need access to the cube definitions this is necessary. the folder
created for RepositoryConnectionString can be shared and the path as
\\machinename\\sharedfolder\file name against this.

RemoteLocksDirectory: Similar to the Remote Repository Connection string
this needs to be done.

This gives access of the cube definitions to other applications which try
using AS2005 cubes.

Hope this helps.

Regards,
Sumit

Hi,

I'm trying to build an OLAP Cube in MSP Server 2007 beta (resting on SQL
Server 2005 and using Analysis Services 2005). I have tried about 6 times or
so and am consistently getting this error.

===== Process Completed =====
[11/8/2006 12:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Query (1, 10) Parser: The
syntax for ',' is incorrect.

Does anybody know what this means? Even if the solution is not readily
available, if somebody can let me know what the error message is telling me,
that would be much appreciated.

I posted this question in the MSP Server forum, but I think that a developer
skill set may be more appropriate to answer.

Thanks,
Brian

 

[Sumit]

Hope it worked. I am able to build and process the cube but unable to build
views... it is unable to connect to cube... looks like some authentication
issue..

Let me know if you are able to resolve this.

Regards,
Sumit.

Thanks for sharing this, Sumit!

Hey Brian,
I was finally able to resolve this issue, just follow the steps as under:

The solution to this is to get a copy of the msmdrep.mdb file from a AS2000
installation folder(should be available in the Bin directory) and copy it
over onto AS2005 installation folder of the DBA's choice.( Possibly a New
folder created in the MSSQL.n folder, n is the number for OLAP directory.
Generally this is 2).

After this is done please follow the following procedure.

START-> PROGRAMS->SQL SERVER2005-> SQL MANAGEMENT STUDIO

a) Once the Management Studio Opens it shows Connecting Options.
b) Select Analysis Engine and click connect.
c) On the Object Explorer on the Right the connection to the server is shown.
d) Right click on the server and select Properties.
e) A window opens with the options on the left showing General... Security.
By default the General properties are shown on the right
f) At the end of the window there is a check box saying SHOW ADVANCED or
ADVANCED Properties.
g) Please check the check box.
h) there will many other options added now to the General properties to the
existing ones.
i) On scrolling down you see DSO and then there are 4 fields, one after the
other saying DSO\Repository Connection String etc...

the following options are available for DSO.

RemoteRepositoryConnectionString
RepositoryConnectionString
RemoteLocksDirectory
LocksDirectory

Create a folder in the same folder where the .MDB file was placed and name
it as LocksDirectory. This folder logs any locks that happen when trying to
process a cube, if in instance 2 people try to process the cube at the same
time.
RepositoryConnectionString: Place the path of the .mdb file in this. Or you
can browse and select the .MDB file. Please do not forget to test the
connection before accepting this.

LocksDirectory: This folder is used to log any locks if they are come
across.

RemoteRepositoryConnectionString: For using applications across a network
which need access to the cube definitions this is necessary. the folder
created for RepositoryConnectionString can be shared and the path as
\\machinename\\sharedfolder\file name against this.

RemoteLocksDirectory: Similar to the Remote Repository Connection string
this needs to be done.

This gives access of the cube definitions to other applications which try
using AS2005 cubes.

Hope this helps.

Regards,
Sumit

Hi,

I'm trying to build an OLAP Cube in MSP Server 2007 beta (resting on SQL
Server 2005 and using Analysis Services 2005). I have tried about 6 times or
so and am consistently getting this error.

===== Process Completed =====
[11/8/2006 12:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Query (1, 10) Parser: The
syntax for ',' is incorrect.

Does anybody know what this means? Even if the solution is not readily
available, if somebody can let me know what the error message is telling me,
that would be much appreciated.

I posted this question in the MSP Server forum, but I think that a developer
skill set may be more appropriate to answer.

Thanks,
Brian

 

[Sumit]

Brian,
The problem I am now facing is I can create a new view from the server
through Web access but unable to connect to cube from other machines...

Regards,
Sumit

Thanks for sharing this, Sumit!

Hey Brian,
I was finally able to resolve this issue, just follow the steps as under:

The solution to this is to get a copy of the msmdrep.mdb file from a AS2000
installation folder(should be available in the Bin directory) and copy it
over onto AS2005 installation folder of the DBA's choice.( Possibly a New
folder created in the MSSQL.n folder, n is the number for OLAP directory.
Generally this is 2).

After this is done please follow the following procedure.

START-> PROGRAMS->SQL SERVER2005-> SQL MANAGEMENT STUDIO

a) Once the Management Studio Opens it shows Connecting Options.
b) Select Analysis Engine and click connect.
c) On the Object Explorer on the Right the connection to the server is shown.
d) Right click on the server and select Properties.
e) A window opens with the options on the left showing General... Security.
By default the General properties are shown on the right
f) At the end of the window there is a check box saying SHOW ADVANCED or
ADVANCED Properties.
g) Please check the check box.
h) there will many other options added now to the General properties to the
existing ones.
i) On scrolling down you see DSO and then there are 4 fields, one after the
other saying DSO\Repository Connection String etc...

the following options are available for DSO.

RemoteRepositoryConnectionString
RepositoryConnectionString
RemoteLocksDirectory
LocksDirectory

Create a folder in the same folder where the .MDB file was placed and name
it as LocksDirectory. This folder logs any locks that happen when trying to
process a cube, if in instance 2 people try to process the cube at the same
time.
RepositoryConnectionString: Place the path of the .mdb file in this. Or you
can browse and select the .MDB file. Please do not forget to test the
connection before accepting this.

LocksDirectory: This folder is used to log any locks if they are come
across.

RemoteRepositoryConnectionString: For using applications across a network
which need access to the cube definitions this is necessary. the folder
created for RepositoryConnectionString can be shared and the path as
\\machinename\\sharedfolder\file name against this.

RemoteLocksDirectory: Similar to the Remote Repository Connection string
this needs to be done.

This gives access of the cube definitions to other applications which try
using AS2005 cubes.

Hope this helps.

Regards,
Sumit

Hi,

I'm trying to build an OLAP Cube in MSP Server 2007 beta (resting on SQL
Server 2005 and using Analysis Services 2005). I have tried about 6 times or
so and am consistently getting this error.

===== Process Completed =====
[11/8/2006 12:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Query (1, 10) Parser: The
syntax for ',' is incorrect.

Does anybody know what this means? Even if the solution is not readily
available, if somebody can let me know what the error message is telling me,
that would be much appreciated.

I posted this question in the MSP Server forum, but I think that a developer
skill set may be more appropriate to answer.

Thanks,
Brian

 

[Guidho]

You need to install ASOLEDB 9.0 on the client machines which need
connectivity to build and view OLAP cubes.

Guidho

Brian,
The problem I am now facing is I can create a new view from the server
through Web access but unable to connect to cube from other machines...

Regards,
Sumit

Thanks for sharing this, Sumit!

Hey Brian,
I was finally able to resolve this issue, just follow the steps as under:

The solution to this is to get a copy of the msmdrep.mdb file from a AS2000
installation folder(should be available in the Bin directory) and copy it
over onto AS2005 installation folder of the DBA's choice.( Possibly a New
folder created in the MSSQL.n folder, n is the number for OLAP directory.
Generally this is 2).

After this is done please follow the following procedure.

START-> PROGRAMS->SQL SERVER2005-> SQL MANAGEMENT STUDIO

a) Once the Management Studio Opens it shows Connecting Options.
b) Select Analysis Engine and click connect.
c) On the Object Explorer on the Right the connection to the server is shown.
d) Right click on the server and select Properties.
e) A window opens with the options on the left showing General... Security.
By default the General properties are shown on the right
f) At the end of the window there is a check box saying SHOW ADVANCED or
ADVANCED Properties.
g) Please check the check box.
h) there will many other options added now to the General properties to the
existing ones.
i) On scrolling down you see DSO and then there are 4 fields, one after the
other saying DSO\Repository Connection String etc...

the following options are available for DSO.

RemoteRepositoryConnectionString
RepositoryConnectionString
RemoteLocksDirectory
LocksDirectory

Create a folder in the same folder where the .MDB file was placed and name
it as LocksDirectory. This folder logs any locks that happen when trying to
process a cube, if in instance 2 people try to process the cube at the same
time.
RepositoryConnectionString: Place the path of the .mdb file in this. Or you
can browse and select the .MDB file. Please do not forget to test the
connection before accepting this.

LocksDirectory: This folder is used to log any locks if they are come
across.

RemoteRepositoryConnectionString: For using applications across a network
which need access to the cube definitions this is necessary. the folder
created for RepositoryConnectionString can be shared and the path as
\\machinename\\sharedfolder\file name against this.

RemoteLocksDirectory: Similar to the Remote Repository Connection string
this needs to be done.

This gives access of the cube definitions to other applications which try
using AS2005 cubes.

Hope this helps.

Regards,
Sumit

:

Hi,

I'm trying to build an OLAP Cube in MSP Server 2007 beta (resting on SQL
Server 2005 and using Analysis Services 2005). I have tried about 6 times or
so and am consistently getting this error.

===== Process Completed =====
[11/8/2006 12:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Query (1, 10) Parser: The
syntax for ',' is incorrect.

Does anybody know what this means? Even if the solution is not readily
available, if somebody can let me know what the error message is telling me,
that would be much appreciated.

I posted this question in the MSP Server forum, but I think that a developer
skill set may be more appropriate to answer.

Thanks,
Brian

 

[Sumit]

Thanks for your response Guidho. I did install "Microsoft SQL Server 2005
Analysis Services 9.0 OLE DB Provider" and "Microsoft Core XML Services
(MSXML) 6.0" but now when I open the page it just hangs... everytime I open a
Data Analysis report i need to kill the page as it hangs...

Did i do anything wrong or miss anything? Do we need to change the protocol
or something?

Regards,
Sumit.

You need to install ASOLEDB 9.0 on the client machines which need
connectivity to build and view OLAP cubes.

Guidho

Brian,
The problem I am now facing is I can create a new view from the server
through Web access but unable to connect to cube from other machines...

Regards,
Sumit

Thanks for sharing this, Sumit!

:

Hey Brian,
I was finally able to resolve this issue, just follow the steps as under:

The solution to this is to get a copy of the msmdrep.mdb file from a AS2000
installation folder(should be available in the Bin directory) and copy it
over onto AS2005 installation folder of the DBA's choice.( Possibly a New
folder created in the MSSQL.n folder, n is the number for OLAP directory.
Generally this is 2).

After this is done please follow the following procedure.

START-> PROGRAMS->SQL SERVER2005-> SQL MANAGEMENT STUDIO

a) Once the Management Studio Opens it shows Connecting Options.
b) Select Analysis Engine and click connect.
c) On the Object Explorer on the Right the connection to the server is shown.
d) Right click on the server and select Properties.
e) A window opens with the options on the left showing General... Security.
By default the General properties are shown on the right
f) At the end of the window there is a check box saying SHOW ADVANCED or
ADVANCED Properties.
g) Please check the check box.
h) there will many other options added now to the General properties to the
existing ones.
i) On scrolling down you see DSO and then there are 4 fields, one after the
other saying DSO\Repository Connection String etc...

the following options are available for DSO.

RemoteRepositoryConnectionString
RepositoryConnectionString
RemoteLocksDirectory
LocksDirectory

Create a folder in the same folder where the .MDB file was placed and name
it as LocksDirectory. This folder logs any locks that happen when trying to
process a cube, if in instance 2 people try to process the cube at the same
time.
RepositoryConnectionString: Place the path of the .mdb file in this. Or you
can browse and select the .MDB file. Please do not forget to test the
connection before accepting this.

LocksDirectory: This folder is used to log any locks if they are come
across.

RemoteRepositoryConnectionString: For using applications across a network
which need access to the cube definitions this is necessary. the folder
created for RepositoryConnectionString can be shared and the path as
\\machinename\\sharedfolder\file name against this.

RemoteLocksDirectory: Similar to the Remote Repository Connection string
this needs to be done.

This gives access of the cube definitions to other applications which try
using AS2005 cubes.

Hope this helps.

Regards,
Sumit

:

Hi,

I'm trying to build an OLAP Cube in MSP Server 2007 beta (resting on SQL
Server 2005 and using Analysis Services 2005). I have tried about 6 times or
so and am consistently getting this error.

===== Process Completed =====
[11/8/2006 12:01 AM] Failed to build the OLAP cubes. Error: Analysis
Services session failed with the following error: Query (1, 10) Parser: The
syntax for ',' is incorrect.

Does anybody know what this means? Even if the solution is not readily
available, if somebody can let me know what the error message is telling me,
that would be much appreciated.

I posted this question in the MSP Server forum, but I think that a developer
skill set may be more appropriate to answer.

Thanks,
Brian