BA Update[solved]

vyanku

Please tell me any one how to update the cube automatically ?

Arhontis

If you have properly installed everything then there is a job in the job scheduler of SQL which is run whenever you want to update the cubes... manualy or auto with schedule...

vyanku

But when It exucutes it shows me error invalid user name and password
DTS package failed
Why it shows me this type of error?

Arhontis

Hmmm,

You could check the user that is setup in the dts (at the connections to the source and desctination database) so that it has permission to login to those databases...

Maybe that user that is setup has not the permission to login to Nav database and to the BA data database...

vyanku

I place the same user to all of them
as a windows login user.
When I job is sxecucated automatically then it shows me error in username and password are invalid.
Bur if I am trying to run the data trnsformation service manually then it shows me error in SQL SERVER AGENT as :-
Unable to read local eventlog(reason:The data area passed to a system call is too small)

And also got error in process ing cube
as
The execution of the following DTS Package succeeded:

Package Name: BA for MBS-NAvision 400 - Process Cubes
Package Description: Build 84
Package ID: {C426E338-5FCA-48DA-B7AC-CFEA6AB225B2}
Package Version: {AF6174C6-3119-481B-973F-1C2DD744079B}
Package Execution Lineage: {1BC8F788-2755-427E-AD7C-A93CD7103519}
Executed On: NAVSION1
Executed By: navision1
Execution Started: 11/21/2006 12:01:03 PM
Execution Completed: 11/21/2006 12:01:10 PM
Total Execution Time: 6.531 seconds

Package Steps execution information:


Step 'DTSStep_DTSTask_DTSOlapProcess.Task_1' succeeded
Step Execution Started: 11/21/2006 12:01:03 PM
Step Execution Completed: 11/21/2006 12:01:08 PM
Total Step Execution Time: 4.953 seconds
Progress count in Step: 0
Task Log for this step:

---

Start Task Log

---

Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 **************************************************************************
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 *
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 * Processing Database 'BA for MBS Navision 400'
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 * Server: NAVSION1
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 * User: NAVISION0\navision1
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 * Time Processing started: 11/21/2006 12:01:06 PM
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 * Log ID: 7246
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 *
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 **************************************************************************
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 Initiating transaction in Database 'BA for MBS Navision 400'
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 Processing Dimension 'Company' Start time: 12:01:06 PM
Error = 1 (00000001), Description = 11/21/2006 12:01:06 PM 7246 Initializing Dimension 'Company'
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Dimension 'Company' Execute : SELECT DISTINCT "wCompany1"."Name" FROM "dbo"."wCompany" AS "wCompany1"
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Completed Processing Dimension 'Company'. End time: 12:01:07 PM Duration: 0:00:01 Rows processed: 2
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Processing Dimension 'Entry Type' Start time: 12:01:07 PM
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Initializing Dimension 'Entry Type'
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Dimension 'Entry Type' Execute : SELECT DISTINCT "eEntryType1"."Value" FROM "dbo"."eEntryType" AS "eEntryType1"
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Completed Processing Dimension 'Entry Type'. End time: 12:01:07 PM Duration: 0:00:00 Rows processed: 18
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Processing Dimension 'Posting Date' Start time: 12:01:07 PM
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Initializing Dimension 'Posting Date'
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Dimension 'Posting Date' Execute : SELECT DISTINCT "wPostingDate1"."YearName", "wPostingDate1"."QuarterNumber", "wPostingDate1"."QuarterName", "wPostingDate1"."MonthNumber", "wPostingDate1"."MonthName1", "wPostingDate1"."DateNumber", "wPostingDate1"."DateName" FROM "dbo"."wPostingDate" AS "wPostingDate1"
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Completed Processing Dimension 'Posting Date'. End time: 12:01:07 PM Duration: 0:00:00 Rows processed: 1
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Processing Dimension 'Vendor Name' Start time: 12:01:07 PM
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Initializing Dimension 'Vendor Name'
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Dimension 'Vendor Name' Execute : SELECT DISTINCT "nVendor1"."Name" FROM "dbo"."nVendor" AS "nVendor1"
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Completed Processing Dimension 'Vendor Name'. End time: 12:01:07 PM Duration: 0:00:00 Rows processed: 1
Error = 1 (00000001), Description = 11/21/2006 12:01:07 PM 7246 Committing transaction in Database 'BA for MBS Navision 400'
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 7246 Committed transaction in Database 'BA for MBS Navision 400'

---

End Task Log

---

Step 'DTSStep_DTSTask_DTSOlapProcess.Task_2' succeeded
Step Execution Started: 11/21/2006 12:01:08 PM
Step Execution Completed: 11/21/2006 12:01:10 PM
Total Step Execution Time: 1.485 seconds
Progress count in Step: 0
Task Log for this step:

---

Start Task Log

---

Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 **************************************************************************
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 *
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 * Processing Database 'BA for MBS Navision 400'
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 * Server: NAVSION1
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 * User: NAVISION0\navision1
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 * Time Processing started: 11/21/2006 12:01:08 PM
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 * Log ID: 3942
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 *
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 **************************************************************************
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 Initiating transaction in Database 'BA for MBS Navision 400'
Error = 1 (00000001), Description = 11/21/2006 12:01:08 PM 3942 Processing Cube 'Vendor Ledger Entry' Start time: 12:01:08 PM
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Initializing Cube 'Vendor Ledger Entry'
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Processing Partition 'Vendor Ledger Entry' Start time: 12:01:09 PM
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Initializing Partition 'Vendor Ledger Entry'
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Partition 'Vendor Ledger Entry' Execute : SELECT "wCompany1"."Name", "nVendor1"."Name", "eEntryType1"."Value", "wPostingDate1"."YearName", "wPostingDate1"."QuarterNumber", "wPostingDate1"."MonthNumber", "wPostingDate1"."DateNumber", "nDetailedVendorLedgEntry1"."Amount", "nDetailedVendorLedgEntry1"."Amount(LCY)", "nDetailedVendorLedgEntry1"."DebitAmount(LCY)", "nDetailedVendorLedgEntry1"."CreditAmount(LCY)" FROM "dbo"."nDetailedVendorLedgEntry" AS "nDetailedVendorLedgEntry1", "dbo"."wCompany" AS "wCompany1", "dbo"."nVendor" AS "nVendor2", "dbo"."nVendor" AS "nVendor1", "dbo"."eEntryType" AS "eEntryType1", "dbo"."wPostingDate" AS "wPostingDate1" WHERE ("nDetailedVendorLedgEntry1"."CompanyCode"="wCompany1"."Code") AND ("nVendor2"."No"="nVendor1"."No") AND ("nVendor2"."CompanyCode"="nVendor1"."CompanyCode") AND ("nDetailedVendorLedgEntry1"."VendorNo"="nVendor2"."No") AND ("nDetailedVendorLedgEntry1"."CompanyCode"="nVendor2"."CompanyCode") AND ("nDetailedVendorLedgEntry1"."EntryType"="eEntryType1"."Code") AND ("nDetailedVendorLedgEntry1"."PostingDate"="wPostingDate1"."TheDate")
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Writing data of Partition 'Vendor Ledger Entry' (segment 1). Rows processed: 1
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Writing aggregations and indexes of Partition 'Vendor Ledger Entry' (segment 1)
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Completed Processing Partition 'Vendor Ledger Entry'. End time: 12:01:09 PM Duration: 0:00:00 Rows processed: 1
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Completed Processing Cube 'Vendor Ledger Entry'. End time: 12:01:09 PM Duration: 0:00:01
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Committing transaction in Database 'BA for MBS Navision 400'
Error = 1 (00000001), Description = 11/21/2006 12:01:09 PM 3942 Committed transaction in Database 'BA for MBS Navision 400'

---

End Task Log

---

For more information, see Help and Support Center at

Arhontis

Maybe there is something wrong in the installation...
Have you tried running the Configurator within Navision BA form?

Running the configurator that way it deletes the databases and rebuild them... Like the first time you run it...

vyanku

What do u mean by

Have you tried running the Configurator within Navision BA form?

When I tried to strart configurator it unstalls previous database and installed new database.

But i can see the cube in BA and analise it very well.Means there is no installation problem.But on updating the cube it shows me error.

Arhontis

I meant exactly that (run the configurator)...

The log you posted earlier does not shows any errors... All tasks seem to have been executed correctly...

The tasks are scheduled every day to be executed, take a look at the execution log of each of the tasks if they have been executed sometime in the night (default time is 2:00 at night, you can see it in the BA Db. Schedules in Nav) succesfully... Or if your data you see through the business analytics client have been updated with the data from yesterday...

It is automaticaly been scheduled through SQL Agent at night because of the potential large amount of new data that your database has each day...

vyanku

Thanks Arhontis
Now I can suscessfully run the Job at shedule time.
And now my data also suscessfully updated.
Thanks =D> \:D/ :whistle:

Arhontis

I am very glad that it works...

If you have any feedback on how you managed to overcome the problem it would be usefull to post it here for future reference, so it might help somebody else in the future...