Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 280 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
facing problem in configuring BA in Nav 4.0 Native DB
sonia
Member Posts: 2
hello everyone
I am facing a problem while running the Configurator in Nav 4.o SP3 , the error is
"Exectution of SSIS Package" I checked the log file SSIS package is not able to execute MBS Navision Database.
The log file is....
Can someone solve this problem.
********************** Started: Thursday, December 11, 2008 3:41:42 PM **********************
Language: w1
Database: C:\Program Files\Microsoft Business Solutions-Navision\Client\DATBASE.FDB
3:41:42 PM: Initialize
Read XML
3:41:42 PM: Check NODBC
3:41:42 PM: Check for SQL Server 2005
3:41:42 PM: Check for Analysis Services 2005
3:41:49 PM: Installation started
3:41:49 PM: Build Internal Representation
3:41:49 PM: Installation completed
********************** Started: Thursday, December 11, 2008 3:42:10 PM **********************
Language: w1
Database: C:\Program Files\Microsoft Business Solutions-Navision\Client\DATBASE.FDB
3:42:10 PM: Initialize
Read XML
3:42:11 PM: Check NODBC
3:42:11 PM: Check for SQL Server 2005
3:42:11 PM: Check for Analysis Services 2005
3:42:13 PM: Installation started
3:42:13 PM: Build Internal Representation
Companies
Enumerations
Shared Dimensions
Cubes
Reference Dimensions
Virtual Cubes
Transfer
Period Table Tasks
3:43:27 PM: Create N/ODBC Data Sources
3:43:27 PM: Install Custom SSIS Tasks
Uninstalling
Installing
3:43:32 PM: Create SQL Server Database
Create database "BA for MBS Navision"
Create table "eIncome_Balance"
Create table "eEntryType"
Create table "eItemLedgerEntryType"
Create table "eValueEntryEntryType"
Create table "eOpportunityEntryActive"
Create table "nGenBusinessPostingGroup"
Create table "nGenProductPostingGroup"
Create table "nSourceCode"
Create table "nJob"
Create table "nPhase"
Create table "nStep"
Create table "nTask"
Create table "nResource"
Create table "nGLAccount"
Create table "nItem"
Create table "nLocation"
Create table "nGLBudgetName"
Create table "nCustomer"
Create table "nCountry"
Create table "nTerritory"
Create table "nVendor"
Create table "nSalespersonPurchaser"
Create table "nCampaign"
Create table "nCampaignStatus"
Create table "nOpportunity"
Create table "nSalesCycle"
Create table "nSalesCycleStage"
Create table "nContact"
Create table "nInventoryPostingGroup"
Create table "wADDepartment"
Create table "wADProject"
Create table "wADCustomerGroup"
Create table "wADArea"
Create table "wADBusinessGroup"
Create table "wADSalescampaign"
Create table "wIsClosingDate"
Create table "nOpportunityEntry"
Create table "nDimensionValue"
Create table "nLedgerEntryDimension"
Create table "nGLBudgetDimension"
Create table "nGLEntry"
Create table "wLedgerEntryDimensionGLEntry"
Create table "nGLBudgetEntry"
Create table "wGLBudgetDimensionGLBudgetEntry"
Create table "nDetailedCustLedgEntry"
Create table "wLedgerEntryDimensionDetailedCustLedgEntry"
Create table "nDetailedVendorLedgEntry"
Create table "wLedgerEntryDimensionDetailedVendorLedgEntry"
Create table "nItemLedgerEntry"
Create table "wLedgerEntryDimensionItemLedgerEntry"
Create table "nValueEntry"
Create table "wLedgerEntryDimensionValueEntry"
Create table "nJobLedgerEntry"
Create table "wLedgerEntryDimensionJobLedgerEntry"
Create table "nResLedgerEntry"
Create table "wLedgerEntryDimensionResLedgerEntry"
Create table "wLedgerEntryDimensionOpportunityEntry"
3:44:00 PM: Create SSIS Package (Part 1)
Create sequence "Initialize"
Create Data Flow "Transfer" (CRONUS India Ltd.)
Create pump Gen. Business Posting Group
Create pump Gen. Product Posting Group
Create pump Source Code
Create pump Job
Create pump Phase
Create pump Step
Create pump Task
Create pump Resource
Create pump G/L Account
Create pump Item
Create pump Location
Create pump G/L Budget Name
Create pump Customer
Create pump Country
Create pump Territory
Create pump Vendor
Create pump Salesperson/Purchaser
Create pump Campaign
Create pump Campaign Status
Create pump Opportunity
Create pump Sales Cycle
Create pump Sales Cycle Stage
Create pump Contact
Create pump Inventory Posting Group
Create pump Opportunity Entry
Create pump Dimension Value
Create pump Ledger Entry Dimension
Create pump G/L Budget Dimension
Create pump G/L Entry
Create pump G/L Budget Entry
Create pump Detailed Cust. Ledg. Entry
Create pump Detailed Vendor Ledg. Entry
Create pump Item Ledger Entry
Create pump Value Entry
Create pump Job Ledger Entry
********************** Started: Thursday, December 11, 2008 3:53:07 PM **********************
Language: w1
Database: C:\Program Files\Microsoft Business Solutions-Navision\Client\DATBASE.FDB
3:53:08 PM: Initialize
Read XML
3:53:08 PM: Check NODBC
3:53:08 PM: Check for SQL Server 2005
3:53:10 PM: Check for Analysis Services 2005
3:53:13 PM: Installation started
3:53:13 PM: Build Internal Representation
Companies
Enumerations
Shared Dimensions
Cubes
Reference Dimensions
Virtual Cubes
Transfer
Period Table Tasks
3:54:24 PM: Create N/ODBC Data Sources
3:54:24 PM: Install Custom SSIS Tasks
Uninstalling
Installing
3:54:28 PM: Create SQL Server Database
Drop database "BA for MBS Navision"
Create database "BA for MBS Navision"
Create table "eIncome_Balance"
Create table "eEntryType"
Create table "eItemLedgerEntryType"
Create table "eValueEntryEntryType"
Create table "eOpportunityEntryActive"
Create table "nGenBusinessPostingGroup"
Create table "nGenProductPostingGroup"
Create table "nSourceCode"
Create table "nJob"
Create table "nPhase"
Create table "nStep"
Create table "nTask"
Create table "nResource"
Create table "nGLAccount"
Create table "nItem"
Create table "nLocation"
Create table "nGLBudgetName"
Create table "nCustomer"
Create table "nCountry"
Create table "nTerritory"
Create table "nVendor"
Create table "nSalespersonPurchaser"
Create table "nCampaign"
Create table "nCampaignStatus"
Create table "nOpportunity"
Create table "nSalesCycle"
Create table "nSalesCycleStage"
Create table "nContact"
Create table "nInventoryPostingGroup"
Create table "wADDepartment"
Create table "wADProject"
Create table "wADCustomerGroup"
Create table "wADArea"
Create table "wADBusinessGroup"
Create table "wADSalescampaign"
Create table "wIsClosingDate"
Create table "nOpportunityEntry"
Create table "nDimensionValue"
Create table "nLedgerEntryDimension"
Create table "nGLBudgetDimension"
Create table "nGLEntry"
Create table "wLedgerEntryDimensionGLEntry"
Create table "nGLBudgetEntry"
Create table "wGLBudgetDimensionGLBudgetEntry"
Create table "nDetailedCustLedgEntry"
Create table "wLedgerEntryDimensionDetailedCustLedgEntry"
Create table "nDetailedVendorLedgEntry"
Create table "wLedgerEntryDimensionDetailedVendorLedgEntry"
Create table "nItemLedgerEntry"
Create table "wLedgerEntryDimensionItemLedgerEntry"
Create table "nValueEntry"
Create table "wLedgerEntryDimensionValueEntry"
Create table "nJobLedgerEntry"
Create table "wLedgerEntryDimensionJobLedgerEntry"
Create table "nResLedgerEntry"
Create table "wLedgerEntryDimensionResLedgerEntry"
Create table "wLedgerEntryDimensionOpportunityEntry"
3:54:54 PM: Create SSIS Package (Part 1)
Create sequence "Initialize"
Create Data Flow "Transfer" (CRONUS India Ltd.)
Create pump Gen. Business Posting Group
Create pump Gen. Product Posting Group
Create pump Source Code
Create pump Job
Create pump Phase
Create pump Step
Create pump Task
Create pump Resource
Create pump G/L Account
Create pump Item
Create pump Location
Create pump G/L Budget Name
Create pump Customer
Create pump Country
Create pump Territory
Create pump Vendor
Create pump Salesperson/Purchaser
Create pump Campaign
Create pump Campaign Status
Create pump Opportunity
Create pump Sales Cycle
Create pump Sales Cycle Stage
Create pump Contact
Create pump Inventory Posting Group
Create pump Opportunity Entry
Create pump Dimension Value
Create pump Ledger Entry Dimension
Create pump G/L Budget Dimension
Create pump G/L Entry
Create pump G/L Budget Entry
Create pump Detailed Cust. Ledg. Entry
Create pump Detailed Vendor Ledg. Entry
Create pump Item Ledger Entry
Create pump Value Entry
Create pump Job Ledger Entry
Create pump Res. Ledger Entry
Create sequence "Post Process"
3:57:49 PM: Execute SSIS Package
Execute package "BA for MBS Navision"
4:06:02 PM: Installation completed
Thanx
Sonia
I am facing a problem while running the Configurator in Nav 4.o SP3 , the error is
"Exectution of SSIS Package" I checked the log file SSIS package is not able to execute MBS Navision Database.
The log file is....
Can someone solve this problem.
********************** Started: Thursday, December 11, 2008 3:41:42 PM **********************
Language: w1
Database: C:\Program Files\Microsoft Business Solutions-Navision\Client\DATBASE.FDB
3:41:42 PM: Initialize
Read XML
3:41:42 PM: Check NODBC
3:41:42 PM: Check for SQL Server 2005
3:41:42 PM: Check for Analysis Services 2005
3:41:49 PM: Installation started
3:41:49 PM: Build Internal Representation
3:41:49 PM: Installation completed
********************** Started: Thursday, December 11, 2008 3:42:10 PM **********************
Language: w1
Database: C:\Program Files\Microsoft Business Solutions-Navision\Client\DATBASE.FDB
3:42:10 PM: Initialize
Read XML
3:42:11 PM: Check NODBC
3:42:11 PM: Check for SQL Server 2005
3:42:11 PM: Check for Analysis Services 2005
3:42:13 PM: Installation started
3:42:13 PM: Build Internal Representation
Companies
Enumerations
Shared Dimensions
Cubes
Reference Dimensions
Virtual Cubes
Transfer
Period Table Tasks
3:43:27 PM: Create N/ODBC Data Sources
3:43:27 PM: Install Custom SSIS Tasks
Uninstalling
Installing
3:43:32 PM: Create SQL Server Database
Create database "BA for MBS Navision"
Create table "eIncome_Balance"
Create table "eEntryType"
Create table "eItemLedgerEntryType"
Create table "eValueEntryEntryType"
Create table "eOpportunityEntryActive"
Create table "nGenBusinessPostingGroup"
Create table "nGenProductPostingGroup"
Create table "nSourceCode"
Create table "nJob"
Create table "nPhase"
Create table "nStep"
Create table "nTask"
Create table "nResource"
Create table "nGLAccount"
Create table "nItem"
Create table "nLocation"
Create table "nGLBudgetName"
Create table "nCustomer"
Create table "nCountry"
Create table "nTerritory"
Create table "nVendor"
Create table "nSalespersonPurchaser"
Create table "nCampaign"
Create table "nCampaignStatus"
Create table "nOpportunity"
Create table "nSalesCycle"
Create table "nSalesCycleStage"
Create table "nContact"
Create table "nInventoryPostingGroup"
Create table "wADDepartment"
Create table "wADProject"
Create table "wADCustomerGroup"
Create table "wADArea"
Create table "wADBusinessGroup"
Create table "wADSalescampaign"
Create table "wIsClosingDate"
Create table "nOpportunityEntry"
Create table "nDimensionValue"
Create table "nLedgerEntryDimension"
Create table "nGLBudgetDimension"
Create table "nGLEntry"
Create table "wLedgerEntryDimensionGLEntry"
Create table "nGLBudgetEntry"
Create table "wGLBudgetDimensionGLBudgetEntry"
Create table "nDetailedCustLedgEntry"
Create table "wLedgerEntryDimensionDetailedCustLedgEntry"
Create table "nDetailedVendorLedgEntry"
Create table "wLedgerEntryDimensionDetailedVendorLedgEntry"
Create table "nItemLedgerEntry"
Create table "wLedgerEntryDimensionItemLedgerEntry"
Create table "nValueEntry"
Create table "wLedgerEntryDimensionValueEntry"
Create table "nJobLedgerEntry"
Create table "wLedgerEntryDimensionJobLedgerEntry"
Create table "nResLedgerEntry"
Create table "wLedgerEntryDimensionResLedgerEntry"
Create table "wLedgerEntryDimensionOpportunityEntry"
3:44:00 PM: Create SSIS Package (Part 1)
Create sequence "Initialize"
Create Data Flow "Transfer" (CRONUS India Ltd.)
Create pump Gen. Business Posting Group
Create pump Gen. Product Posting Group
Create pump Source Code
Create pump Job
Create pump Phase
Create pump Step
Create pump Task
Create pump Resource
Create pump G/L Account
Create pump Item
Create pump Location
Create pump G/L Budget Name
Create pump Customer
Create pump Country
Create pump Territory
Create pump Vendor
Create pump Salesperson/Purchaser
Create pump Campaign
Create pump Campaign Status
Create pump Opportunity
Create pump Sales Cycle
Create pump Sales Cycle Stage
Create pump Contact
Create pump Inventory Posting Group
Create pump Opportunity Entry
Create pump Dimension Value
Create pump Ledger Entry Dimension
Create pump G/L Budget Dimension
Create pump G/L Entry
Create pump G/L Budget Entry
Create pump Detailed Cust. Ledg. Entry
Create pump Detailed Vendor Ledg. Entry
Create pump Item Ledger Entry
Create pump Value Entry
Create pump Job Ledger Entry
********************** Started: Thursday, December 11, 2008 3:53:07 PM **********************
Language: w1
Database: C:\Program Files\Microsoft Business Solutions-Navision\Client\DATBASE.FDB
3:53:08 PM: Initialize
Read XML
3:53:08 PM: Check NODBC
3:53:08 PM: Check for SQL Server 2005
3:53:10 PM: Check for Analysis Services 2005
3:53:13 PM: Installation started
3:53:13 PM: Build Internal Representation
Companies
Enumerations
Shared Dimensions
Cubes
Reference Dimensions
Virtual Cubes
Transfer
Period Table Tasks
3:54:24 PM: Create N/ODBC Data Sources
3:54:24 PM: Install Custom SSIS Tasks
Uninstalling
Installing
3:54:28 PM: Create SQL Server Database
Drop database "BA for MBS Navision"
Create database "BA for MBS Navision"
Create table "eIncome_Balance"
Create table "eEntryType"
Create table "eItemLedgerEntryType"
Create table "eValueEntryEntryType"
Create table "eOpportunityEntryActive"
Create table "nGenBusinessPostingGroup"
Create table "nGenProductPostingGroup"
Create table "nSourceCode"
Create table "nJob"
Create table "nPhase"
Create table "nStep"
Create table "nTask"
Create table "nResource"
Create table "nGLAccount"
Create table "nItem"
Create table "nLocation"
Create table "nGLBudgetName"
Create table "nCustomer"
Create table "nCountry"
Create table "nTerritory"
Create table "nVendor"
Create table "nSalespersonPurchaser"
Create table "nCampaign"
Create table "nCampaignStatus"
Create table "nOpportunity"
Create table "nSalesCycle"
Create table "nSalesCycleStage"
Create table "nContact"
Create table "nInventoryPostingGroup"
Create table "wADDepartment"
Create table "wADProject"
Create table "wADCustomerGroup"
Create table "wADArea"
Create table "wADBusinessGroup"
Create table "wADSalescampaign"
Create table "wIsClosingDate"
Create table "nOpportunityEntry"
Create table "nDimensionValue"
Create table "nLedgerEntryDimension"
Create table "nGLBudgetDimension"
Create table "nGLEntry"
Create table "wLedgerEntryDimensionGLEntry"
Create table "nGLBudgetEntry"
Create table "wGLBudgetDimensionGLBudgetEntry"
Create table "nDetailedCustLedgEntry"
Create table "wLedgerEntryDimensionDetailedCustLedgEntry"
Create table "nDetailedVendorLedgEntry"
Create table "wLedgerEntryDimensionDetailedVendorLedgEntry"
Create table "nItemLedgerEntry"
Create table "wLedgerEntryDimensionItemLedgerEntry"
Create table "nValueEntry"
Create table "wLedgerEntryDimensionValueEntry"
Create table "nJobLedgerEntry"
Create table "wLedgerEntryDimensionJobLedgerEntry"
Create table "nResLedgerEntry"
Create table "wLedgerEntryDimensionResLedgerEntry"
Create table "wLedgerEntryDimensionOpportunityEntry"
3:54:54 PM: Create SSIS Package (Part 1)
Create sequence "Initialize"
Create Data Flow "Transfer" (CRONUS India Ltd.)
Create pump Gen. Business Posting Group
Create pump Gen. Product Posting Group
Create pump Source Code
Create pump Job
Create pump Phase
Create pump Step
Create pump Task
Create pump Resource
Create pump G/L Account
Create pump Item
Create pump Location
Create pump G/L Budget Name
Create pump Customer
Create pump Country
Create pump Territory
Create pump Vendor
Create pump Salesperson/Purchaser
Create pump Campaign
Create pump Campaign Status
Create pump Opportunity
Create pump Sales Cycle
Create pump Sales Cycle Stage
Create pump Contact
Create pump Inventory Posting Group
Create pump Opportunity Entry
Create pump Dimension Value
Create pump Ledger Entry Dimension
Create pump G/L Budget Dimension
Create pump G/L Entry
Create pump G/L Budget Entry
Create pump Detailed Cust. Ledg. Entry
Create pump Detailed Vendor Ledg. Entry
Create pump Item Ledger Entry
Create pump Value Entry
Create pump Job Ledger Entry
Create pump Res. Ledger Entry
Create sequence "Post Process"
3:57:49 PM: Execute SSIS Package
Execute package "BA for MBS Navision"
4:06:02 PM: Installation completed
Thanx
Sonia
0
Comments
I think u have to upgrade ur Database into HOTFIX. I have already faced this same issue. You can download Hotfixes from Microsoft partner source. I think this is the only solution..
Just see this link for your reference.. (you have to login into partner source, then only you can see this link) https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYXUPYZQPOUXNXSPSYOMPRYORVUYTULPMRSLNMUPTKXQPSYZZXYULKNZOMQVOPRNOSOQPPXVXTKZPVZYNT...
Thanks,
Divya