Linked Server Establishment from sql 2012 to sql 2005
Hi,
Can you please help me to establish the link server between sql server 2012 std edition to sql server 2005 please.
Expecting the steps to establish.
I tried , but end up with error.
The steps i tried is
log in to sql server 2012 ( source ) and in the SSMS, expand the server objects + Linked Server
2. right click on the linked server and select new link server, which will prompt us with new wizard, in which we need to enter the name
3. i have given the name of the link server, same as my destination instance name . and under that we have ser ver type of 2 radio buttons a. SQL server b. Other DataTypes, in whcih i have choosen SQL Server as my destiantion serv er is also SQL
4. choosen security tab on the left side of the wizard , i had given my log in id only in local login , remote user, remote password category
5. clicked the final OK button , but end up with error .
Please correct me if i am wrong.
thanks
hemadri
Reply:
Hello,
Please read the following article about how to configure the linked server including the security context that will be used.
http://www.databasejournal.com/features/mssql/article.php/3691721/Setting-up-a-Linked-Server-for-a-Remote-SQL-Server-Instance.htm
Share with us the full error message if you still receive the error.
Consider to configure Windows Firewall (or any security software) to allow SQL Server access.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
------------------------------------
Reply:
------------------------------------
Reply:
Please share error message you are getting.
Also Check SQL Server connectivity for SQL 2005 from SQL 2012.
Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.
------------------------------------
Win7Pro: Using "netsh rpc add 127.0.0.1" or "rpccfg -a 1" causes RPC subsystem to crash.
On reboot. RPC will quickly crash and the system will force shutdown (in one minute).
Tried classic (XP) "ListenOnInternet"="N" registry key: no effect.
Tried enabling all interfaces explicitly (rpccfg): Works but useless.
Tried disabling NIC card: Works but useless (no connectivity).
Tried enabling all interfaces explicitly except externally connected NIC (rpccfg): Crash.
Added custom loopback interface (Fake NIC) to try and placate RPC: Crash.
Reply:
Hi,
Please run "netsh show settings" and "netsh show interface" (without quotes) commands first.
The subnet address is "127.0.0.0".
Here is one article about netsh rpc can be referred to.
Netsh commands for RPC
http://technet.microsoft.com/en-us/library/cc784909(v=ws.10).aspx#BKMK_3
Hope that helps.
Ivan-Liu
TechNet Community Support
------------------------------------
Reply:
C:\>netsh rpc show settings
Default
C:\>netsh rpc show interfaces
Subnet Interface Status Description
127.0.0.0 127.0.0.1 Enabled Software Loopback Interface 1
192.168.0.0 192.168.0.2 Enabled NETGEAR FA311v2 PCI Adapter
C:\>netsh rpc add 127.0.0.0
C:\>netsh rpc show interfaces
Subnet Interface Status Description
127.0.0.0 127.0.0.1 Enabled Software Loopback Interface 1
192.168.0.0 192.168.0.2 Disabled NETGEAR FA311v2 PCI Adapter
-- Reboot.
-- After login RPC system will crash and the system (W7Pro) will go into "shutdown in 1 minute" mode.
C:\>netsh rpc reset
(Returns it to working system)
------------------------------------
Reply:
------------------------------------
Calling all SSIS Gurus. October readers need feeding!
Hey you!
Want to be a real-life virtual guru? (pun intended)
Do you want to win the love and admiration of the community you work in?
You can win REAL virtual medals and prove your skills, in a competition that is judged by real Microsoft judges!
Gurus who continue to shine soon get noticed!
Oh yes! We're talking inner circles! Nominations! New horizons!
Step up and stand out!
All you have to do is add an article to TechNet Wiki from your own specialist field. Something that fits into one of the categories listed on the submissions page. Copy in your own blog posts, a forum solution, a white paper, or just something you had to solve for your own day's work today.
Drop us some nifty knowledge, or superb snippets, and become MICROSOFT TECHNOLOGY GURU OF THE MONTH!
This is an official Microsoft TechNet recognition, where people such as yourselves can truly get noticed!
HOW TO WIN
1) Please copy over your Microsoft technical solutions and revelations to TechNet Wiki.
2) Add a link to it on THIS WIKI COMPETITION PAGE (so we know you've contributed)
3) Every month, we will highlight your contributions, and select a "Guru of the Month" in each technology.
If you win, we will sing your praises in blogs and forums, similar to the weekly contributor awards. Once "on our radar" and making your mark, you will probably be interviewed for your greatness, and maybe eventually even invited into other inner TechNet/MSDN circles!
Winning this award in your favoured technology will help us learn the active members in each community.
More about TechNet Guru Awards
Thanks in advance!
Pete Laker
TechNet Wiki Community Council Member, Azure MVP, Wiki Ninja & TechNet Guru!
#PEJL
Got any nice code? If you invest time in coding an elegant, novel or impressive answer on MSDN forums, why not copy it over to TechNet Wiki, for future generations to benefit from! You'll never get archived again, and you could win weekly awards!
Have you got what it takes o become this month's TechNet Technical Guru? Join a long list of well known community big hitters, show your knowledge and prowess in your favoured technologies!
Reply:
What is the criteria as far as originality? I have over 20 technical articles on Experts Exchange* ( list ) and have a few sequel articles to write, and am looking for a new place to have them published.
Thanks in advance.
Jim
* Articles are finally in front of the paywall after being behind for the last four years.
- Edited by jim_horn Thursday, October 27, 2016 9:39 PM
------------------------------------
Insiders who are in Release Preview ring. You have a new build.
Cumulative Update KB3197954 available for Insiders who are in Windows 10 PC and Mobile Release Preview ring.
This will bring your build from 14393.321 to 14393.351
- Edited by david hk129 Friday, October 21, 2016 3:10 PM
Reply:
Cumulative Update KB3197954 available for Insiders who are in Windows 10 PC and Mobile Release Preview ring.
This will bring your build from 14393.321 to 14393.351
Strange thing - today Insiders have reported starting to get this CU a second time! See THESE POSTS
------------------------------------
Reply:
Hi Folks,
Using PSWindowsUpdate Module, everything indicates that this CU KB3197954 has been rereleased(the original has disappeared from Get-List but is still in Get-History) plus now accompanied by CU KB3201921. CU KB3197954 is also larger if my memory serves.
I am installing both FOR TEST.
Best Regards,
Crysta
PhotM Phantom of the Mobile
------------------------------------
Reply:
CU KB3197954 is also larger if my memory serves.What size is the newer CU? The cab's for the first release were 419Mb (x86) and 773Mb (x64).
------------------------------------
Reply:
------------------------------------
Reply:
CU KB3197954 is also larger if my memory serves.
What size is the newer CU? The cab's for the first release were 419Mb (x86) and 773Mb (x64).
From PSWindowsUpdate Module:
Get-WUList -IsInstalled
DI--U- KB3201921 63 KB Cumulative Update for Windows 10 Version 1607 for x64-based Systems (KB3201921)DI--U- KB3197954 827 MB Cumulative Update for Windows 10 Version 1607 for x64-based Systems (KB3197954)
DI--U- KB3199986 11 MB Update for Windows 10 Version 1607 for x64-based Systems (KB3199986)
BTW ICYMI;
Windows 10.14393.351 is now RTM(Released to Market)
Best Regards,
Crysta
PhotM Phantom of the Mobile
------------------------------------
State Message issue 6104, 6105 C:\Program Files\Microsoft Configuration Manager\inboxes\auth\statesys.box\corrupt contain 1 500 000 files
Hi, I need some help with SCCM 1511 + SQL 2012
SMS_State_System is critical now.
Errors with next IDs:
6104
The State System message file processing could not process file 'H_XW0MNVCI.SMX' and moved it to the corrupt directory. Review the statesys.log file for further details.
6105
The State System message file processing processed one or more files that contained errors or invalid data. Review the statesys.log file for further details.
Screen from statesys.log
SQL MESSAGE: spProcessStateReport - Error: Message processing encountered a SQL error 515 at record 1 for TopicType 4000: "Cannot insert the value NULL into column 'DeviceID', table 'CM_S02.dbo.MDMDeviceProperty'; column does not allow nulls. UPDATE fails.", Line 0 in procedure ""
SQL MESSAGE: spProcessStateReport - Error: Message processing encountered a SQL error 3621 at record 1 for TopicType 4000: "The statement has been terminated.", Line 0 in procedure ""
CMessageProcessor - Non-fatal error while processing H_OXVYLZ22.SMX
Under folder "C:\Program Files\Microsoft Configuration Manager\inboxes\auth\statesys.box\corrupt" saved > 1 500 000 files and used > 7Gb
SCCM time to time lost clients, counter "SCCM Total online clients" can show 0 or for example 18446744073709552 clients, it's not true, after server restart shows normal value ~ 3000 clients.
Would be very glad for any help.
Regards,
Semen Zhukovskyi
- Changed type Semen Zhukovskyi Monday, July 18, 2016 7:41 PM
- Edited by Semen Zhukovskyi Monday, July 18, 2016 8:09 PM
Reply:
------------------------------------
Window 10 and Plex Media Server Problems
Files Dissappearing after editing file properties
I'm having problems with SP 2013 Document Centers and Records Centers vaporizing files when anyone edits any of the file properties after it has been uploaded to the correct location. Due to the nature of our job, each file requires some unique meta data, so when an individual is uploading a file then wants to edit some of the column information, they will hit the submit button and then an error code comes up saying it cannot find that file. I've checked every location I can, but the files are never found. This is causing employees to not want to use SharePoint. If this continue, I'll have to find another solution.
Has anyone had this issue; if so , could you help me out?
Bubbadrew
Reply:
Hi Bubbadrew- do you have content approval turned on? Do you have an all items view with no filters to check? Do you have any workflows or content organization set on the library? What about check in/out? Settings for the library as to who can see drafts? Have you renamed folders recently? Do they have long URLs? Any other customizations? Have you checked the recycle bin? Any retention policy? If you create a new OOTB doc center, does it work?
Sorry for so many questions, but they'll help us narrow down the issue.
cameron rautmann
------------------------------------
Bug - Cannot Log into Account in an unrecognized server per "Help us Protect your account"
I cannot log into my azure account via Add-AzureAccount in powershell in an unrecognized server.
In order to get this error here are the steps:
1. Create a server on azure I used 2012 R2
2. Install azure powershell on that server
3. Open powershell
4. Add-AzureAccount
5. Need to log in
6. Unrecognized server for your protection insert your email and click next and we will send you a code.
7. Where do I insert my email and where is next?
8. There really isn't a work around for this.
9. Just clicking Send code gives error.
- Edited by demolitiondav Wednesday, March 30, 2016 2:55 PM Enhance explanation
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Script: Last logon machine name based on list of users. Output to Excel with samaccountname, workstation name and location of workstation
Hi!
I have a very difficult from management to find machine names for a big excel list of users. My first thought is to find a script that can find the user's last logon machine name and then output the information by samaccountname, workstation name and location of workstation.
My second thought is to find a script that can to match the users last night with a machine name. Since the machine names are named after they samaccountname. output the information by samaccountname, workstation name and location of workstation.
The latter might be tricky because there are many variations to a machine name due to the fact that some people might have the same name. However It couldn't be that many and I can find these machine manually.
I hope you can help me. Thanks in advance for any help you can provide. Thank you!
-Allen
- Changed type Bill_Stewart Wednesday, December 7, 2016 10:59 PM
- Moved by Bill_Stewart Wednesday, December 7, 2016 10:59 PM This is not "scripts on demand"
Reply:
I'm sure you have seen or read the first post at the top of this forum: This forum is for scripting questions rather than script requests. (Right?)
That said, what have you tried so far, and with what results?
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
Hi Bill,
Thank you for responding. I did not read the rule of the forum. I apologize for this.
I have not attempted to script anything on this because my scripting ability is very limited.
Can you please recommend the proper forum for me to move this question to?
Thank you in advance!
------------------------------------
Reply:
There's not another forum to move this to, but you can post a script request on the script request page. (You will have to look at the links in my earlier post. There is a link in that post to the script request page.) Keep in mind that just posting a request there doesn't guarantee that someone will take the time to write your code for you.
Alternatively, we would recommend learning PowerShell. Your learning investment will pay off in the long run.
-- Bill Stewart [Bill_Stewart]
------------------------------------
An important milestone in enterprise integration – launch of Microsoft BizTalk Server 2016
Hello BizTalk techies,
Today marks the release of Microsoft BizTalk Server 2016. This is an important milestone that not only reinforces strong on-premises application integration capabilities, but also provides flexibility and control to our customers to adopt cloud applications as and when it makes sense for the business. We realize that every company is undergoing digital transformation with the proliferation of applications, data and services. Whether your applications run in the cloud or on-premises, you should have the flexibility to seamlessly connect applications, unlock data and automate business process anywhere.
Why upgrade to BizTalk Server 2016?
Please read below article by Frank Weigel for more details;
An important milestone in enterprise integration – launch of Microsoft BizTalk Server 2016
Thanks,
If my reply is helpful please mark as Answer or vote as Helpful.
My blog | Twitter | LinkedIn
This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.
Reply:
Regards Pushpendra Singh : Please mark the reply as answer or vote it up, as deemed fit.
------------------------------------
Migrating Taskbar settings using USMT Windows 7 to windows 10
Hi
In the past I was able to get USMT to migrate the taskbar customization.
When migrating XP to Win 7 or Win 7 to Win 7, the taskbar location would be applied on the new computer. For example if the user moved his task bar to the right in the new computer after USMT loadstate it will also be aligned to the right.
I'm not able to achieve that in my 1607 ADK on my 1511 Windows (reason I'm using the 1607 is becuase I have office 2016).
Thanks
Rami Metanes
Extract XML Data from same Tag
Hello,
we have table with xml data as below and need to write sql to extract below information:
number | type | nickname
<profile xmlns="http://schemas.com/2008/01/Model/extensions" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <disabledState> <isDisabledIndicator>true</isDisabledIndicator> <disabledDateTime>2012-12-02T07:44:14.640</disabledDateTime> </disabledState> <registeredAccounts> <account> <accountId> <number>031111111111111</number> <type>CC</type> <companyId>PG</companyId> </accountId> <isPrimary>false</isPrimary> <nickname>CC2720</nickname> <transferFromIndicator>true</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>true</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>CC</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> <account> <accountId> <number>0411111111111</number> <type>AHO</type> <companyId>PG</companyId> </accountId> <isPrimary>true</isPrimary> <nickname>AHO8385</nickname> <transferFromIndicator>true</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>true</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>CDA</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> <account> <accountId> <number>0411111116497</number> <type>AHO</type> <companyId>PG</companyId> </accountId> <isPrimary>false</isPrimary> <nickname>AHO6497</nickname> <transferFromIndicator>true</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>true</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>CDA</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> <account> <accountId> <number>0411111110900</number> <type>AHO</type> <companyId>PG</companyId> </accountId> <isPrimary>false</isPrimary> <nickname>AHO0900</nickname> <transferFromIndicator>true</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>true</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>CDA</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> <account> <accountId> <number>0411111110900000003</number> <type>TC</type> <companyId>PG</companyId> </accountId> <isPrimary>false</isPrimary> <nickname>TC0003</nickname> <transferFromIndicator>false</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>false</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>VBGP</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> </registeredAccounts> </profile>
Sachin Butala,System administrator
- Edited by Sachinonnet Thursday, October 27, 2016 8:23 AM
Reply:
Here we go:
DECLARE @xml XML = '<profile xmlns="http://schemas.com/2008/01/Model/extensions" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <disabledState> <isDisabledIndicator>true</isDisabledIndicator> <disabledDateTime>2012-12-02T07:44:14.640</disabledDateTime> </disabledState> <registeredAccounts> <account> <accountId> <number>031111111111111</number> <type>CC</type> <companyId>PG</companyId> </accountId> <isPrimary>false</isPrimary> <nickname>CC2720</nickname> <transferFromIndicator>true</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>true</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>CC</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> <account> <accountId> <number>0411111111111</number> <type>AHO</type> <companyId>PG</companyId> </accountId> <isPrimary>true</isPrimary> <nickname>AHO8385</nickname> <transferFromIndicator>true</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>true</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>CDA</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> <account> <accountId> <number>0411111116497</number> <type>AHO</type> <companyId>PG</companyId> </accountId> <isPrimary>false</isPrimary> <nickname>AHO6497</nickname> <transferFromIndicator>true</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>true</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>CDA</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> <account> <accountId> <number>0411111110900</number> <type>AHO</type> <companyId>PG</companyId> </accountId> <isPrimary>false</isPrimary> <nickname>AHO0900</nickname> <transferFromIndicator>true</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>true</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>CDA</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> <account> <accountId> <number>0411111110900000003</number> <type>TC</type> <companyId>PG</companyId> </accountId> <isPrimary>false</isPrimary> <nickname>TC0003</nickname> <transferFromIndicator>false</transferFromIndicator> <transferToIndicator>true</transferToIndicator> <searchableIndicator>true</searchableIndicator> <billPayIndicator>false</billPayIndicator> <rdcIndicator>false</rdcIndicator> <displayAccountIndicator>true</displayAccountIndicator> <displayTransactionsIndicator>true</displayTransactionsIndicator> <eligibleForAlertRegistration>true</eligibleForAlertRegistration> <p2pFromIndicator>true</p2pFromIndicator> <p2pToIndicator>true</p2pToIndicator> <properties> <property> <key>displayName</key> <value>VBGP</value> </property> </properties> <properties> <property> <key>displayName</key> <value xsi:nil="true"/> </property> </properties> </account> </registeredAccounts> </profile>'; -- convert to relational/rectangular ;WITH XMLNAMESPACES (DEFAULT 'http://schemas.com/2008/01/Model/extensions'), rs AS ( SELECT col.value('nickname[1]','VARCHAR(1024)') AS nickname , col.value('(accountId/number)[1]','VARCHAR(1024)') AS number , col.value('(accountId/type)[1]','VARCHAR(1024)') AS [type] FROM @XML.nodes('/profile/registeredAccounts/account') AS tab(col) ) SELECT * FROM rs; The output:
nickname number type CC2720 031111111111111 CC AHO8385 0411111111111 AHO AHO6497 0411111116497 AHO AHO0900 0411111110900 AHO TC0003 0411111110900000003 TC
------------------------------------
Trying to monitor folder content using a vbs script
Hi guys,
I've found quite a lot of scripts that should have helped to reach my goal, but I didn't manage to adapt it.
My need is to check how my daily loading (from both operational system and then accounting system) has ended in the night.
Currently I do it manually every morning and just checking it takes me 30 minutes (in case everything is ok!). So my plan was to script the several steps I check every morning in a .wsf script (using vb) that I could run through a scheduled task every morning.
As so, it would send me a mail listing for each checked step what having found / missing, so no mail would mean everything went well no need to loose my time to check on it (because hopefully it happens :) ).
My checking steps are the following:
1. For the operational system:
I look in a database the date of last integrated file of each of my local operational systems,
If any isn't at the date of today, then I check that it's not stuck into my working folder (in case it is I will manually fix it and relaunch data loading),
If there is no file stuck in my working folder, first thing I need to check is that it has been well transferred from my XFB server.
If no file stuck in my XFB server, it means that my missing file hasn't been generated / sent by my local operational system so I will ask to my correspondent to check on that.
2. For my accounting system, I daily received files from my local accounting systems:
I look on my archive folder (named Hist, where all previous loaded files are stored), to check if all sub-folder have been updated today (if yes, it means daily data loading is OK)
If there is one not up to date, I'll check that it my processing loading folder (named In, where all files to be loaded are stored) hasn't been locked due to a corrupted file,
If there is none, I'll check that it has been well transferred from my XFB server.
If no file stuck in my XFB server, it means that my missing file hasn't been generated / sent by my local accounting system and I'll need to look on it manually.
Here is the script I've tried to write, but at the first moment I try to run it, an error is raised at a Dim statement declaration and I really to see why...
If anyone could help with this, it would be much appreciated :).
<package> <job id="DailyMonitoring"> <object id="objCnx" progid="ADODB.Connection"/> <object id="objRs" progid="ADODB.Recordset"/> <object id="objShell" progid="WScript.Shell"/> <object id="objFso" progid="Scripting.FileSystemObject"/> <script language = "VBScript"> Const sAPP22PEGFolder = "\\LoadingServer\E$\INFOCENTRE\LOTS\" 'APP22 PEG folder to check if no file stuck Const sAPP22SUNHistFolder = "\\LoadingServer\E$\INF_SUN\Hist\" 'APP22 SUN Hist folder to check if all subfolders are up to date Const sAPP22SUNInFolder = "\\LoadingServer\E$\INF_SUN\In\" 'APP22 SUN IN folder to check if no files stuck Const sAPP78PEGFolder = "\\XFBserver\D$\Infocentre\PEGASE\Batch\" 'XFB server PEG folder to check if no file stuck Const sAPP78SUNFolder = "\\XFBserver\D$\Infocentre\INFSUN\Batch\" 'XFB server SUN folder to check if no file stuck Const sAPP45 = "AccountingDBServer" 'APP45 SUN DB server Const sOutput = "\\LoadingServer\E$\MonitoringResult.txt" 'The name of The output file Const mstrPeg_Host = "OperationalDBServer" Const mstrBD_SQL = "INFOCENTRE" Const mstrUser = "sa" Const mstrPwd = "somepw" Dim oFSO, oOutput, oFolderAPP22, oFolderAPP78 Dim strSQLPEGMissingLots Const CST_SQLOLEDB_CNX = "Provider=SQLOLEDB;Data Source=%1;Initial Catalog=%2;User ID=%3;Password=%4;" strCnx = Replace(CST_SQLOLEDB_CNX, "%1", mstrPeg_Host) strCnx = Replace(strCnx, "%2", mstrBD_SQL) strCnx = Replace(strCnx, "%3", mstrUser) strCnx = Replace(strCnx, "%4", mstrPwd) objCnx.Open strCnx Set oFSO = CreateObject("Scripting.FileSystemObject") Set oOutput = oFSO.CreateTextFile(sOutput, True) oOutput.WriteLine "Start Daily PEG Loading check on " & Date() & "\r\n\r\n" On Error Resume Next Dim countLOTSFiles As Integer Dim countPEGBatchFiles As Integer Dim countSUNBatchFiles As Integer set countLOTSFiles = 0 set countPEGBatchFiles = 0 set countSUNBatchFiles = 0 strSQLPEGMissingLots = "Use INFOCENTRE SELECT distinct f.[C_CODE_BASE] ,o.entity ,f.[C_NUM_LOT] ,convert(char(8),f.[C_DATE_LOT],112)+'\r\n' as C_DATE FROM [INFOCENTRE].[dbo].[LOTS] f inner join (select [C_CODE_BASE] ,max ([C_NUM_LOT]) lot FROM [INFOCENTRE].[dbo].[LOTS] group by [C_CODE_BASE]) s on s.[C_CODE_BASE]=f.[C_CODE_BASE] and s.lot=f.[C_NUM_LOT] left outer join [ASPAC_Reference].[dbo].[DIM_Organization] o on f.c_code_base=o.codebase where s.C_CODE_BASE not in ('auaau','APSGC') and substring(convert(char(8),f.[C_DATE_LOT],112),1,8) <> convert(char(8),getdate(),112) order by C_DATE, c_code_base" set RsPEGMissingLots = objCnx.Execute(strSQLPEGMissingLots) WriteLog("PEG LOTS missing in database: \r\n"& RsPEGMissingLots(0)) If RsPEGMissingLots <> "" Then Set oFolderAPP22 = oFSO.GetFolder(sAPP22PEGFolder) If Err.number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP22PEGFolder & " - " & Err.Description & "\r\n" Else oOutput.WriteLine "\r\n\r\n*** APP22 LOTS Folder content: ***\r\n" For Each oFileAPP22 In oFolderAPP22.Files 'If oFileAPP22.GetExtensionName() = "txt" Then ' voir pour appel du renamefile.exe oOutput.WriteLine oFileAPP22.path Set countLOTSFiles = countLOTSFiles + 1 'End If Next If countLOTSFiles = 0 Then oOutput.WriteLine "\r\n*** No file stuck in APP22 LOTS Folder ***\r\n" On Error Resume Next 'start check APP78 PEG Folder Set oFolderAPP78 = oFSO.GetFolder(sAPP78PEGFolder) If Err.number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP78PEGFolder & " - " & Err.Description & "\r\n" Else oOutput.WriteLine "*** APP78 PEG Batch Folder content: ***\r\n" For Each oFileAPP78 In oFolderAPP78.Files oOutput.WriteLine oFileAPP78.path oOutput.WriteLine "\r\n" Set countPEGBatchFiles = countPEGBatchFiles + 1 Next End If If countPEGBatchFiles = 0 Then oOutput.WriteLine "\r\nNo file stuck in APP78 PEG Batch Folder" End If On Error Goto 0 End If End If On Error Goto 0 Else oOutput.WriteLine "\r\n*** PEG Daily Loading OK ***\r\n" End If oOutput.WriteLine "\r\n*** PEG Daily Loading ended ***\r\n" 'End of PEG Daily Loading monitoring 'Start SUN Daily Loading monitoring oOutput.WriteLine "\r\n*** Start Daily SUN Loading check on " & Date() & " ***\r\n" '-Check APP22 SUN Hist folder Dim oFolderSUNHistFolders, oSUNHistFolder, oSUNInFolders, oFileSUNIn Dim dateModified Dim countSUNHistFiles As Integer Dim countSUNInFiles As Integer set countSUNHistFiles = 0 set countSUNInFiles = 0 On Error Resume Next Set oSUNHistFolders = oFSO.GetFolder(sAPP22SUNHistFolder) If Err.Number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP22SUNHistFolder & " folder - " & Err.Description & "\r\n" Else oOutput.WriteLine "*** APP22 SUN Hist Folder content: ***\r\n" For Each oSUNHistFolder In oSUNHistFolders Do dateModified = oFSO.GetFolder(oSUNHistFolder.Path).DateLastModified If Err.Number <> 0 Then oOutput.WriteLine oSUNHistFolder.Path & " folder: Cannot get the DataLastModified property\r\n" Exit Do End If If dateModified < Date() Then oOutput.WriteLine oSUNHistFolder.Path & " last updated on " & dateModified & "\r\n" Set countSUNHistFiles = countSUNHistFiles + 1 End If 'Check Loop Until True Next If countSUNHistFiles > 0 Then oOutput.WriteLine "Files missing in APP22 SUN Hist Folder" 'start check no files stuck in SUN In Folder On Error Resume Next Set oSUNInFolders = oFSO.GetFolder(sAPP22SUNInFolder) If Err.Number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP22SUNInFolder & " folder - " & Err.Description & "\r\n" Exit Do End If oOutput.WriteLine "\r\n*** APP22 SUN In Folder content: ***\r\n" For Each oFileSUNIn In oSUNInFolders.Files 'If oFileAPP22.GetExtensionName() = "txt" Then ' voir pour appel du renamefile.wsf oOutput.WriteLine oFileSUNIn.path Set countSUNInFiles = countSUNInFiles + 1 'End If Next If countSUNInFiles = 0 Then oOutput.WriteLine "\r\nNo file stuck in APP22 SUN In Folder" On Error Resume Next 'start check APP78VM SUN Folder Set oFolderAPP78 = oFSO.GetFolder(sAPP78SUNFolder) If Err.number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP78SUNFolder & " - " & Err.Description & "\r\n" Else oOutput.WriteLine "*** APP78 SUN Batch Folder content: ***\r\n" For Each oFileAPP78 In oFolderAPP78.Files oOutput.WriteLine oFileAPP78.path oOutput.WriteLine "\r\n" Set countSUNBatchFiles = countSUNBatchFiles + 1 Next End If If countSUNBatchFiles = 0 Then oOutput.WriteLine "\r\nNo file stuck in APP78 SUN Batch Folder, need to check local SUN server" End If On Error Goto 0 End If Else oOutput.WriteLine "\r\n*** SUN Daily Loading OK ***\r\n" End If On Error Goto 0 End If oOutput.WriteLine "\r\n*** SUN Daily Loading ended ***\r\n" oOutput.Close objCnx.close </script> </job> </package> Reply:
To begin with you would find this much easier with PowerShell as it has direct support for what you are doing in the form of "workflow". Also WSF/VBS is near obsolete and is not supported by any new Microsoft software systems.
As for your issue - without a complete error message it is not passible to even guess at your issue.
\_(ツ)_/
------------------------------------
Reply:
You cannot use VB in a WSF. It is not supported. WSF only supports scripting languages written for WSH.
DimcountPEGBatchFiles As Integer
Will throw an error in VBS as VBS does not support type declarations. VBS supports a limited version of VB syntax and is called a "late bound" language so it behaves differently from VB which is an "early bound" language as are all compiled languages. Scripting languages are not compiled they are "parsed" at runtime.
\_(ツ)_/
------------------------------------
Reply:
Hi,
Thanks for the quick answer. I've continued to work on it, and I've been able to fix a few of my statements.
Actual version :
<package> <job id="DailyMonitoring"> <object id="objCnx" progid="ADODB.Connection"/> <object id="objRs" progid="ADODB.Recordset"/> <object id="objShell" progid="WScript.Shell"/> <object id="objFso" progid="Scripting.FileSystemObject"/> <script language = "VBScript"> Const sAPP22PEGFolder = "\\aprsgapp22.aspac.dat.bollore\E$\INFOCENTRE\LOTS\" 'APP22 PEG folder to check if no file stuck Const sAPP22SUNHistFolder = "\\aprsgapp22.aspac.dat.bollore\E$\INF_SUN\Hist\" 'APP22 SUN Hist folder to check if all subfolders are up to date Const sAPP22SUNInFolder = "\\aprsgapp22.aspac.dat.bollore\E$\INF_SUN\In\" 'APP22 SUN IN folder to check if no files stuck Const sAPP78PEGFolder = "\\aprgrsgapp78vm.aspac.dat.bollore\D$\Infocentre\PEGASE\Batch\" 'XFB server PEG folder to check if no file stuck Const sAPP78SUNFolder = "\\aprgrsgapp78vm.aspac.dat.bollore\D$\Infocentre\INFSUN\Batch\" 'XFB server SUN folder to check if no file stuck Const sAPP45 = "aprdcapp45.aspac.dat.bollore" 'APP45 SUN DB server Const sOutput = "\\aprsgapp22.aspac.dat.bollore\E$\MonitoringResult.txt" 'The name of The output file Const mstrPeg_Host = "aprsgapp22" Const mstrBD_SQL = "INFOCENTRE" Const mstrUser = "sa" Const mstrPwd = "cognos" Dim oFSO, oOutput, oFolderAPP22, oFolderAPP78 Dim strSQLPEGMissingLots Const CST_SQLOLEDB_CNX = "Provider=SQLOLEDB;Data Source=%1;Initial Catalog=%2;User ID=%3;Password=%4;" strCnx = Replace(CST_SQLOLEDB_CNX, "%1", mstrPeg_Host) strCnx = Replace(strCnx, "%2", mstrBD_SQL) strCnx = Replace(strCnx, "%3", mstrUser) strCnx = Replace(strCnx, "%4", mstrPwd) objCnx.Open strCnx Set oFSO = CreateObject("Scripting.FileSystemObject") Set oOutput = oFSO.CreateTextFile(sOutput, True) oOutput.WriteLine "Start Daily PEG Loading check on " & Date() & vbCrlf & vbCrlf Const countLOTSFiles = 0 Const countPEGBatchFiles = 0 Const countSUNBatchFiles = 0 strSQLPEGMissingLots = "SELECT distinct f.[C_CODE_BASE] ,o.entity ,f.[C_NUM_LOT] ,convert(char(8),f.[C_DATE_LOT],112)+'\r\n' as C_DATE FROM [INFOCENTRE].[dbo].[LOTS] f inner join (select [C_CODE_BASE] ,max ([C_NUM_LOT]) lot FROM [INFOCENTRE].[dbo].[LOTS] group by [C_CODE_BASE]) s on s.[C_CODE_BASE]=f.[C_CODE_BASE] and s.lot=f.[C_NUM_LOT] left outer join [ASPAC_Reference].[dbo].[DIM_Organization] o on f.c_code_base=o.codebase where s.C_CODE_BASE not in ('auaau','APSGC') and substring(convert(char(8),f.[C_DATE_LOT],112),1,8) <> convert(char(8),getdate(),112) order by C_DATE, c_code_base" set RsPEGMissingLots = objCnx.Execute(strSQLPEGMissingLots) oOutput.WriteLine "PEG LOTS missing in database: \r\n" & RsPEGMissingLots(0)) If RsPEGMissingLots <> "" Then Set oFolderAPP22 = oFSO.GetFolder(sAPP22PEGFolder) If Err.number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP22PEGFolder & " - " & Err.Description & "\r\n" Else oOutput.WriteLine "\r\n\r\n*** APP22 LOTS Folder content: ***\r\n" For Each oFileAPP22 In oFolderAPP22.Files 'If oFileAPP22.GetExtensionName() = "txt" Then ' voir pour appel du renamefile.exe oOutput.WriteLine oFileAPP22.path Set countLOTSFiles = countLOTSFiles + 1 'End If Next If countLOTSFiles = 0 Then oOutput.WriteLine "\r\n*** No file stuck in APP22 LOTS Folder ***\r\n" On Error Resume Next 'start check APP78 PEG Folder Set oFolderAPP78 = oFSO.GetFolder(sAPP78PEGFolder) If Err.number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP78PEGFolder & " - " & Err.Description & "\r\n" Else oOutput.WriteLine "*** APP78 PEG Batch Folder content: ***\r\n" For Each oFileAPP78 In oFolderAPP78.Files oOutput.WriteLine oFileAPP78.path oOutput.WriteLine "\r\n" Set countPEGBatchFiles = countPEGBatchFiles + 1 Next End If If countPEGBatchFiles = 0 Then oOutput.WriteLine "\r\nNo file stuck in APP78 PEG Batch Folder" End If On Error Goto 0 End If End If On Error Goto 0 Else oOutput.WriteLine "\r\n*** PEG Daily Loading OK ***\r\n" End If oOutput.WriteLine "\r\n*** PEG Daily Loading ended ***\r\n" 'End of PEG Daily Loading monitoring 'Start SUN Daily Loading monitoring oOutput.WriteLine "\r\n*** Start Daily SUN Loading check on " & Date() & " ***\r\n" '-Check APP22 SUN Hist folder Dim oFolderSUNHistFolders, oSUNHistFolder, oSUNInFolders, oFileSUNIn Dim dateModified Const countSUNHistFiles = 0 Const countSUNInFiles = 0 On Error Resume Next Set oSUNHistFolders = oFSO.GetFolder(sAPP22SUNHistFolder) If Err.Number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP22SUNHistFolder & " folder - " & Err.Description & "\r\n" Else oOutput.WriteLine "*** APP22 SUN Hist Folder content: ***\r\n" For Each oSUNHistFolder In oSUNHistFolders Do dateModified = oFSO.GetFolder(oSUNHistFolder.Path).DateLastModified If Err.Number <> 0 Then oOutput.WriteLine oSUNHistFolder.Path & " folder: Cannot get the DataLastModified property\r\n" Exit Do End If If dateModified < Date() Then oOutput.WriteLine oSUNHistFolder.Path & " last updated on " & dateModified & "\r\n" Set countSUNHistFiles = countSUNHistFiles + 1 End If 'Check Loop Until True Next If countSUNHistFiles > 0 Then oOutput.WriteLine "Files missing in APP22 SUN Hist Folder" 'start check no files stuck in SUN In Folder On Error Resume Next Set oSUNInFolders = oFSO.GetFolder(sAPP22SUNInFolder) If Err.Number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP22SUNInFolder & " folder - " & Err.Description & "\r\n" Exit Do End If oOutput.WriteLine "\r\n*** APP22 SUN In Folder content: ***\r\n" For Each oFileSUNIn In oSUNInFolders.Files 'If oFileAPP22.GetExtensionName() = "txt" Then ' voir pour appel du renamefile.wsf oOutput.WriteLine oFileSUNIn.path Set countSUNInFiles = countSUNInFiles + 1 'End If Next If countSUNInFiles = 0 Then oOutput.WriteLine "\r\nNo file stuck in APP22 SUN In Folder" On Error Resume Next 'start check APP78VM SUN Folder Set oFolderAPP78 = oFSO.GetFolder(sAPP78SUNFolder) If Err.number <> 0 Then oOutput.WriteLine "Cannot access " & sAPP78SUNFolder & " - " & Err.Description & "\r\n" Else oOutput.WriteLine "*** APP78 SUN Batch Folder content: ***\r\n" For Each oFileAPP78 In oFolderAPP78.Files oOutput.WriteLine oFileAPP78.path oOutput.WriteLine "\r\n" Set countSUNBatchFiles = countSUNBatchFiles + 1 Next End If If countSUNBatchFiles = 0 Then oOutput.WriteLine "\r\nNo file stuck in APP78 SUN Batch Folder, need to check local SUN server" End If On Error Goto 0 End If Else oOutput.WriteLine "\r\n*** SUN Daily Loading OK ***\r\n" End If On Error Goto 0 End If oOutput.WriteLine "\r\n*** SUN Daily Loading ended ***\r\n" oOutput.Close objCnx.close </script> </job> </package> To be said, it works good until my DB select, but when I try to get the result, I assume I'm not using a good type of variable (I guess a tab would be needed?). Error raised is "expected end of statement".
jrv, I'm barely able to write some code in VB and I don't know anything about PowerShell so it's hard to me to go in that direction.
------------------------------------
Reply:
You ae wasting your time with VBS. PowerShell is much easier to learn as it can be run interactively at a prompt one line at a time.
As for your error - please understand that in a technical forum it is critical that you post the complete error message and not just part of the text.
"expected end of statement is another syntax error. It means you have a mistake in your tying or structure and we cannot help you find it. Sometimes this kind of mistake requires running only small parts of the code in a test harness until you isolate your mistake.
\_(ツ)_/
- Edited by jrv Thursday, October 27, 2016 11:01 AM
------------------------------------
Reply:
\_(ツ)_/
------------------------------------
Reply:
See the first post from the top of this forum:
This forum is for scripting questions rather than script requests
One of the bullet points in that post:
- I have posted my 500-line script. Can someone find that elusive bug and fix it for me?
So basically what you are doing is posting a "code dump" and then asking others to embark on a debugging session for you. That's not the purpose of this forum.
-- Bill Stewart [Bill_Stewart]
------------------------------------
We have recently upgraded the scom 2012 r2 UR5 to UR9
Hi ,
we have done the all installations steps. and all Mserver and consoles and web updated to UR9
3) Execute MSP files from an elevated command prompt, Install server.msp on all Management Servers
4) Install the gatway.msp file on gateway servers
5) Install Webcolsole.msp package on web server
6) Run console.msp on all the console servers
7) Apply the SQL Scripts on both Ops DB & DW
In the path on your management servers, where you installed/extracted the update, there are two SQL script files:
%SystemDrive%\Program Files\Microsoft System Center 2012 R2\Operations Manager\Server\SQL Script for Update Rollups
8) Import the Management Packs Manually.
9) Update the Agents
Note: Actually we are connecting the console from Citrix server. but still console running with UR5. when i connect console when i click the active alerts getting no issue. if click the windows computer tab will getting the error.
My question is: this issue is happening boz of console is not upgrading in Citrix servers to UR9.
Please clarify me on this.
Regards,
Anji
Reply:
Jason | http://blog.configmgrftw.com | @jasonsandys
------------------------------------
No Distribution points when creating Pre-Stage files
I have come across a problem when trying to pre-stage content by means of creating a pre-stage file.
After selected "create pre-stage file content" and crating the file name when trying to select a distribution point, the list is empty
See below
Any ideas ?
Reply:
Hi,
Is the content distributed to a DP in the environment already? That is required to create the prestage content from.
Regards,
Jörgen
-- My System Center blog ccmexec.com -- Twitter @ccmexec
------------------------------------
Reply:
I tried to distribute it, but i get an asset message "distribution manager is waiting for package ****** content to be pre-staged.
from doing some digging around i understand the way around is is to crate pre-stage file ?
------------------------------------
Reply:
Torsten Meringer | http://www.mssccmfaq.de
------------------------------------
Reply:
Even in a single site (non CAS) setup ?
Are you suggesting i set another DP (new server) ?
------------------------------------
Reply:
Jason | http://blog.configmgrftw.com | @jasonsandys
------------------------------------
Reply:
Hey again,
The DP is already installed on the single server. we use it to deploy windows updates.
Why its not showing under distribution point, i have no idea.
------------------------------------
Reply:
Torsten Meringer | http://www.mssccmfaq.de
------------------------------------
Reply:
Hey Torsten,
Yes, this is correct, see below:
------------------------------------
Reply:
This setup will not work. You have only one DP and it's configured for prestaged content. You will need to clear this check box or select the Automatically download content for Prestaged distribution point settings for each package/application.
My recommendation is to uncheck that checkbox, this is an unusual setup.
------------------------------------
Reply:
Torsten Meringer | http://www.mssccmfaq.de
------------------------------------
Reply:
Hey,
It has been handed over to me for previous person ! trying to work things out.
------------------------------------
Reply:
------------------------------------
Reply:
Start by unchecking the "Enable this distribution point for prestaged content" checkbox. This will set you off on the right path to work things out.Thanks for all the help. this has resolved my problem.
------------------------------------
The report execution has expired / An error occured within the ReportServer database
Hi,
Please can someone help with this ongoing issue. I have 3 dashboard reports which refresh every 5 mins (bar charts). Initially these were parameterised but this was giving an error after a few hours of running. The error was "The report execution vz0vta455tsvll45vm5pfg45 has expired or cannot be found. After much digging I felt that the parameters were the issue because they used the IN clause (was documented on a another thread). Now I have removed the parameters and hardcoded the values within datasets with page breaks for each former parameter option. However after leaving the dashboard obernight I got this error today "An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database". I've increased timeout settings and checked disk space but not getting any closer to resolving this. A typical error in th log files looks like this:
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.;
session!ReportServer_0-76!71e8!10/26/2016-02:59:02:: e ERROR: Error in getting session data: Expired Session: vz0vta455tsvll45vm5pfg45
session!ReportServer_0-76!71e8!10/26/2016-02:59:02:: i INFO: LoadSnapshot: Item with session: vz0vta455tsvll45vm5pfg45, reportPath: , userName: BLUETREE2000\xxxxx not found in the database
I just need to refresh the report without it crashing. I didnt think it would be so difficult.
Please help as this is becoming increasingly urgent with no sign of any light and the end....
Thanks
Reply:
Hi,
Usually, the error: "An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database" occurs due to a large size or bad rows of some tables in the ReportServerTempDB database. Also, check the authorization.
------------------------------------
Reply:
Hi,
I'm only working with around 80K rows in the table so pretty small dataset. ReportServerTempDB doesn't suggest anything obvious. Authorisation is set to Windows Authentication.
The report crashed again overnight with the initial report execution expired error. I have set the refresh to 5 minutes.
Thanks for your help on this...
Appreciate any other advice.
------------------------------------
Mobile Device Migration from Airwatch MDM to Microsoft Intune MDM
Hi,
Also please suggest is any Migration approach/way available to migrate the managed Mobile devices from Airwatch MDM to Intune MDM??
Shailendra Dev
Reply:
Gerry Hampson | Blog: www.gerryhampsoncm.blogspot.ie | LinkedIn: Gerry Hampson | Twitter: @gerryhampson
------------------------------------
Reply:
Hi,
When moving to Intune apart from un-enrolling devices from Airwatch are there any other steps for migrating? What happens to the applications purchased through Apple VPP I assume they are stored on the Apple account and will sync across to Intune when you add the token to Intune?
Thanks :)
------------------------------------
Do DBA's do this work?
Alan
Reply:
------------------------------------
Reply:
The network guys say I am responsible for Windows updates. Formatting the drives. Setting up partition alignment. Etc.
Hey I only wish they would let me do some of that stuff. In most big shops they have teams to do the setup, and some of those team members call themselves DBA's. Formatting drives, partitions? With modern SANs I don't know, I haven't formatted a drive in ten years, not even at home.
I did format a couple of thumb drives with FAT32.
Josh
- Edited by JRStern Thursday, October 27, 2016 4:03 AM
------------------------------------
Reply:
The network guys say I am responsible for Windows updates. Formatting the drives. Setting up partition alignment. Etc.Not that I have seen how are all these related to SQL Server, ask him. I suggest you set your priorities straight with him to avoid future conflict
Alan
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from itMy TechNet Wiki Articles
MVP
------------------------------------
Reply:
Normally, NO this is not SQL DBA task.
SQL DBA primary responsible for SQL Server only.
If at time of joining they mention windows administration as your roles and responsibilities than you have to look into this.
Although all this is not related to Network guys as well.
Please get in touch with Windows Admin team, Its there primary responsibilities to do all this. You can give your suggestion like disk size, block size, update configuration etc.
Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.
------------------------------------
Reply:
I would suggest even if its not the DBA task (which I think its not), but you need to know how to verify it. At least making sure that all the alignment is correct (now a days normally are).
Windows update should be a windows task, but with SQL 2012 or 2014 onwards, you might want to know what is being update as well. Note that is knowing, not performing the actual update task. Since some update will not include SQL, so you need to make sure you know if any patches they do is going to affect you.
------------------------------------
Paging with number sharepoint list item
Hi,
I am using JSOM to show list item which will have paging also.
For next/previous it is working but I want the page number also so that users can directly navigate to particular page content without clicking next repeatedly.
I heard sharepoint jsom does not swupport direct page wise paging it supports only prev and next.
Is there any other method to achieve it.
Reply:
If you are only dealing with limited number of items say 500 or less, it would be easier to cache it locally and manipulate it. If you have to deal with more than that please refer the below example to use the skip and top to get data from pages.
https://stackoverflow.com/questions/26305776/office-365-sharepoint-api-skip-skiptoken-functionality
Thanks & Regards, Balu
------------------------------------
Reply:
$skiptoken=Paged=TRUE&p_ID=<last item id to skip>&$top=<items count>
here the p_ID is always the last retrieved item ID but i have to navigate to 3rd page item directly.
------------------------------------
Pass-The-Ticket Exclusion?
Hi all,
This is a question for my own information and knowledge as I'm new to ATA.
In ATA, I understand the need for DNS Reconnaissance IP exclusions. There may be machines where legitimate DNS administrative tasks need to be performed, and you don't want these machines triggering alerts in ATA when someone runs the NSLookup command etc.
What I'm trying to get my head around is why you would want Pass-The-Ticket IP Address exclusions. What is the scenario where you would add an IP or IP Range to be excluded from PtT alerting?
http://www.dreamension.net
Reply:
Ok so... I managed to ask someone else at Microsoft and I found some information regarding this. I thought I would share in case someone else has this same question in the future.
Sometimes false positive Pass-The-Ticket alerts can happen when automated services are used. Think of things like a backup solution using a privileged service account in the middle of the night that's hitting a lot of different servers. Or maybe an automated orchestration that runs etc.
So when/if you get these false positives from these known sources and known events - this is where you can exclude their IP addresses from alerting in ATA.
Hopefully that will help someone else in the future...
http://www.dreamension.net
------------------------------------
No comments:
Post a Comment