Monthly Archives: February 2015

Fix: DBAMP Error: MALFORMED_QUERY: Implementation restriction: CollaborationGroupRecord requires a filter by a single Id, CollaborationGroupId or RecordId using the equals operator

Actual problem is the procedure fails to pull CollaborationGroupRecord table data due to api restrictions. You need to exclude the table from sf_replicateAll and/or sf_RefreshAll procedures as a resolution. Fix: Add below 2 lines of code next to < if … Continue reading

Posted in Referene, SQL Error, Useful Link | Tagged , , , , , , , | Leave a comment

PowerShell03 – PowerShell script basics

Windows PowerShell script is a collection of Windows PowerShell Cmdlets/Commands. PowerShell scripts can be executed like batch files and it can also be configured to run as scheduled task! I will share few basics to start with PowerShell Scripting… • … Continue reading

Posted in Learn_Powershell, Powershell | Tagged , , , | Leave a comment

Fix – SSIS to Oracle connectivity issue during run time (Error code: 0x8007007E/0xC0202009)

SSIS package started failing when I execute the package though all validations are successful. The failure was related to oracle connection failure. Fix: I had to change the package to Execute in 32 bit to fix the connectivity failure. Change … Continue reading

Posted in SQL, SQL Error, SSIS | Tagged , , , , | 3 Comments

Powershell02 – CmdLet Parameters, Variables

Cmdlets can accept parameters which can be used while processing cmdlets. I would like to talk about 2 types of parameters, Default parameters and named parameters • Default parameter: If the parameter is default parameter, you do not have to … Continue reading

Posted in Learn_Powershell, Powershell | Tagged , , , | Leave a comment

Report Data Pane is missing – Latest SQL Version – SystemInfo – Azure Infographics

Just want to share something interesting I have come across in last few weeks… ALT + CTRL + D is the shortcut to get the Report Data Pane back. At times you will not be able to see the shortcut! … Continue reading

Posted in commands, knowledge, Productivity, Referene | Tagged , , , , , | Leave a comment

LearnPowerShell 01 – Basics for first time PowerShell users

Installation: PowerShell is expected to be installed on your Windows-7/ Windows-8 machine by default. If not already installed, use instructions at https://technet.microsoft.com/en-us/library/hh847837.aspx to install PowerShell. How to Open (Powershell/ Powershell ISE): Run Powershell / Powershell_ISE commands to start using PowerShell … Continue reading

Posted in Learn_Powershell, Powershell | Tagged , , , , , | Leave a comment

Solution – Error: Could not retrieve initialization strings. Run DBAmp Configuration program and press OK on Options dialog.

SF_Replicate fails with below error: Error: Could not retrieve initialization strings. Run DBAmp Configuration program and press OK on Options dialog. NOTE: At times, you may encounter this error when you execute SF_RefreshAll with “Yes” option and when it tries … Continue reading

Posted in SQL, Useful Link | Tagged , , , , | Leave a comment