Cannot create AW using AWM from Schema Sales History in Oracle 10.1.0.3.0

10-11  Source: Network gathering  Views:1 

Advertisement
Hi,
I have installed Oracle DB Enterprise Edition and Client 10.1.0.3.0 on Linux.
I create the schema SH using the scripts sh_main.sql, csh_v3.sql, lsh_v3.sql, psh_v3.sql and olp_v3.sql from the directory $ORACLE_HOME/demo/schema/sales_history. So far, everything is ok.
Next, I tried to create an analytic workspace from this schema using the analytic workspace manager. An error ocurred (see AAA...), because of the string "e-mail" in the dimension attribute of CUSTOMERS_DIM. Changing "e-mail" to "email" solved this problem.
During the next try, an error occured because of the PERIOD_END_DATE attribute (see BBB...). Can somebody find a solution to this problem?
Best regards,
Ralph
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
Creating analytic workspace...
Processing cube SALES_CUBE
Processing Creating Dimension : CHANNELS_DIM
Processing Creating Dimension : CUSTOMERS_DIM
Error Message from Server = ___AW_REFRESH_DIMENSION
E-MAIL is not allowed to contain non-standard form characters SH_AW.MYAW
Problem getting Attributes for:
SH
CUSTOMERS_DIM
You provided extra input starting at '$'.
In SYS.AWXML!__XML_VAL_PREFIX PROGRAM:
exists = exists(name)
Problem creating dimension:
CUSTOMERS_DIM
You provided extra input starting at '$'.
In SYS.AWXML!__XML_VAL_PREFIX PROGRAM:
exists = exists(name)
SqlException = ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.DBMS_AWM", line 975
ORA-06512: at line 1
Error Code = 6510
Sql State = 65000
BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
Creating analytic workspace...
Processing cube SALES_CUBE
Processing Creating Dimension : CHANNELS_DIM
Processing Creating Dimension : CUSTOMERS_DIM
Processing Creating Dimension : PRODUCTS_DIM
Processing Creating Dimension : PROMOTIONS_DIM
Processing Creating Dimension : TIMES_DIM
Processing Defining Load for Dimension: CHANNELS_DIM
Processing Refreshing Dimension : CHANNELS_DIM
Processing Defining Load for Dimension: CUSTOMERS_DIM
Processing Refreshing Dimension : CUSTOMERS_DIM
Processing Defining Load for Dimension: PRODUCTS_DIM
Processing Refreshing Dimension : PRODUCTS_DIM
Processing Defining Load for Dimension: PROMOTIONS_DIM
Processing Refreshing Dimension : PROMOTIONS_DIM
Processing Defining Load for Dimension: TIMES_DIM
Processing Refreshing Dimension : TIMES_DIM
Error Message from Server = Problem refreshing dimension:
TIMES_DIM
TIMES_DIM.PERIOD_END_DATE.ATTRIBUTE is not a Valid Attribute.
(AW$XML) AW$XML
In SYS.AWXML!__XML_HANDLE_ERROR PROGRAM:
then signal 'AW$XML' 'AW$XML'
SqlException = ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.DBMS_AWM", line 1012
ORA-06512: at line 1
Error Code = 6510
Sql State = 65000
Please apply the OLAP 10.1.0.3.0A or OLAP 10.1.0.3.0B patch to both the Database Server and Database Client. Do not run Oracle OLAP on the RDMBS 10.1.0.3 patch set without either one of these OLAP specific patches:
OLAP 10.1.0.3.0A patch (PS #3769360 on MetaLink)
OLAP 10.1.0.3.0B patch (PS #4045047 on MetaLink)
The B patch contains all the fixes found in the A patch, plus additional fixes. Therefore, I would recommend B over A.
Related articles
  • Cannot create AW using AWM from Schema Sales History in Oracle 10.1.0.3.0 10-11

    Hi, I have installed Oracle DB Enterprise Edition and Client 10.1.0.3.0 on Linux. I create the schema SH using the scripts sh_main.sql, csh_v3.sql, lsh_v3.sql, psh_v3.sql and olp_v3.sql from the directory $ORACLE_HOME/demo/schema/sales_history. So fa

  • I need help I want to analyze and create reports using data from my firefox history files . 11-30

    I am not quite sure where to post this. I had a program for analyzing my firefox history which no longer works due to the change in how firefox stores history data. I am not an sqlite user. Any help will be greatly appreciated. I downloaded the sqlit

  • Error while creating AW using AWM 10-11

    I am using AWM version 10.2.0.3.0, Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod. Using the user apps when trying to create an AW using AWM. Schema->apps-> Analytic Workspace -> Create Analytic Workspace I get an error oracle.e

  • Getting an error while creating a ERP Quotation from CRM Sales Web-UI. 10-11

    Hi Experts, I am getting an error while creating a ERP quotation from CRM Sales Web-UI. Here  I am enclosing the screen shot. Please give me the solution for this.Thank you in advance. Regards Kishor Kumar.Hi Kishore, Please refer to the link below -

  • Create a Credit Memo from invoice  (Sales) 11-30

    Hi How Can I Create a Credit Memo from invoice (Sales)? ThanksHi Joe, Check our SDK sample C:\Program Files\SAP\SAP Business One SDK\Samples\COM DI\VB.NET\05.OrderAndInvoice to understand the procedure. You will have to create your own sample by usin

  • Cannot create an Essbase connection from Workspace 11-30

    Hi all, I have a new install and I cannot create a Essbase connection from Workspace. I can successfully create the essbase connection from Reporting Studio but I can't use that connection from Workspace. It seems like Workspace can't connect to Essb

  • How to create an Installed base from the sales order 10-11

    Dear Friends, could any one let me know the process of creating an Installed base with the below process. Once a sales order is created in SD, an istalled base need to be created in CRM system with reference to sales order. There are around 50 final

  • How do you create a purchase order from a sales order? 10-11

    Is there a specific patch level for B1 2005 that implements this, is it a feature only in B1 2007 or does it have to be custom coded? If this has to be custom coded, does anyone either have sample code or a module that could be purchased that impleme

  • Create XML using data from Oracle 10-11

    Other than using OracleXMLQuery, how do I create an XML file from the data from a table in Oracle? Rgds, SeeteshVetsrini: Thanks for your response. I no longer can receive email at [email protected], because I am at a different company now. So please

  • Cannot create report using DAD 11-30

    Hi, I have created a DAD under the HTTP Server (under mod_plsql services) for a remote database. In the list of DADs, it shows a green arrow indicating that the connection can be established. Now, I want to create Report Portlet in my portal page. Wh

  • Cannot Create PDF Using "Create PDF" Function in Acrobat 8 11-30

    I can create by using "save as" in my Office programs, but only from the Windows Explorer box, not from the menu.  However, I can no longer "create pdf" nor "combine files" inside Acrobat 8.  I get reinstall message.  It star

  • Error when trying to create a delivery note from a sales order -  Internal error (-2010) occurred 10-11

    Hi I am trying to create a delivery note form a sales order in B1 V9 PL8 and I am getting the following error - Internal error (-2010) occurred The code has been working but we seem to be getting problems now Can anyone suggest anything please ? Copy

  • Problems with loading source model using omw from sql server 7 into oracle 9i 11-30

    I am migrating data from sql servr 7 into oracle 9i. when doing capture phase i get the following error. ==>failed to load source model.[microsoft][odbc sql server][sql server]select permission denied on column 'password' of object 'syslogins', datab

  • Cannot create A/R Invoice from Delivery 10-11

    Hi everyone. I have a Delivery based on a Sales Order and want to make an A/R Invoice from the Delivery using the "Copy to" button on the Delivery form. When I do that I get the following message: "One or more down payment that are linked t

  • Create pdf using data from another pdf 10-11

    Hi, I need to automate the following process. A user fills in a pdf form(on a website) and submits it. A notification is sent to the appropriate person of the submission. This person will add in more information in the same form and when finished, cl

  • Cannot create SAPUI5 UI Component from a BPM Process 10-11

    Dear friends, For a very strange reason I am not able to create a SAPUI5 UI Component from a BPM Process. I am trying to create SAPUI5 UI's for an Human task as part of my BPM process. I am using NWDS 7.3 EHP1 SP15 PAT0000. We are using NWDI developm

  • Good document for creating cube using AWM wih oracle 10.1.0.2 version 11-30

    Can anyone provide some good guide for implementing the OLAP cubes using ORACLE ver 10.1.0.2.0 with AWM Release 1. Also, please let me know whether I need to apply any patches. The demo provided under this link has some differences when trying to imp

  • Create database using datafiles from cold backup 11-30

    hi, I've been given a bunch of datafiles from a cold backup. I have created my own database using the same DB_NAME as the original. I now want to be able to attach these datafiles to my database. How do I go about? Do I need to start the database in

  • Error while creating a production order from a sales order 10-11

    Hi    Even though the product has BOM when i try to create order with a sales order reference it is showing a warning message " NO BOM FOUND" . How to correct this error . regards, PradeepM.Dear , Goto -CS02-Enter FG -Goto Header -Staus Long Tex

  • Create Query using data from 0IC_C03 to show stock balance 11-30

    Dear All, I have successfully setup 0IC_C03. I have loaded in the data in accordance with the documentation. I check the result and it seems the stock balance match with the data source. However, my question is how can I setup a formula in the query