dbTalk Databases Forums  

AS 2005 Processing Error?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss AS 2005 Processing Error? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MarkFrank
 
Posts: n/a

Default AS 2005 Processing Error? - 06-06-2006 , 04:35 PM






Hi all,

I have a new cube that reads all fact table records, creates partitions than
fails just before commiting with the error below.


MdxScript(HE ODS) (17, 11) Parser: The syntax for ';' is incorrect.

Any suggestions would be appreciated in advance.

Thanks,

Mark



Reply With Quote
  #2  
Old   
Designing-Systems.com
 
Posts: n/a

Default RE: AS 2005 Processing Error? - 06-08-2006 , 08:22 AM






hi,

most probably your MDX syntax is incorrect or you have used the ; where it
is not required. In the Deployment widow follow the deployment steps to
identify the failing process / step.

Regards,
-------------------------------------------------
http://www.Designing-Systems.com
Email. Support (AT) Designing-Systems (DOT) com
--------------------------------------------------

"MarkFrank" wrote:

Quote:
Hi all,

I have a new cube that reads all fact table records, creates partitions than
fails just before commiting with the error below.


MdxScript(HE ODS) (17, 11) Parser: The syntax for ';' is incorrect.

Any suggestions would be appreciated in advance.

Thanks,

Mark



Reply With Quote
  #3  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: AS 2005 Processing Error? - 06-08-2006 , 08:36 AM



There is a syntax error in your MDX script somewhere (Probably and extra
semi-colon). If you open the calculations tab of your "HE ODS" cube you
should find an error at line 16, column 10. If you have a look in the
Error List window it should tell you the exact location.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <769612CC-F571-4F3F-BE21-39A5B58A19A4 (AT) microsoft (DOT) com>,
MarkFrank (AT) discussions (DOT) microsoft.com says...
Quote:
Hi all,

I have a new cube that reads all fact table records, creates partitions than
fails just before commiting with the error below.


MdxScript(HE ODS) (17, 11) Parser: The syntax for ';' is incorrect.

Any suggestions would be appreciated in advance.

Thanks,

Mark




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.