SharePoint InfoPath 2007 Integration

Sharing and keep track on this :)

SharePoint InfoPath 2007 Integration

View more documents from Biz Support Online.

About Alert email issues

Issues : new item assign to task list , owner not receive alert

Step to check:

stsadm -o getproperty -pn job-immediate-alerts -url http://abc.com/sites/XXXX

this command is check the alert timer job status :

Restults:
<Property Exist="Yes" Value="every 5 minutes between 0 and 59" />
which  mean the alert timer will check every 5 minutes.
*normally this is standard setting

Next Step:

Run following command to check from SQL server whether new item created or not :
· use [content_DB
]
select top 50 itemname,EventData,ACL,* from EventCache order by EventTime desc

you should see the new created item , else which mean something wrong.

Solution :

create new list and try again.

ha ha..is not perfect solution but anyhow let me resolve mine problem.

just notice have good post about the alert :
http://msmvps.com/blogs/bradley/archive/2009/03/22/how-to-troubleshoot-alerts-in-wss-3-0-moss.aspx

Only with Document library permission is unable to subscribe Alert me!

Issues :

 

user only have full control permission at document library, when user try to click on alert me setting then will show Error: Access Denied

 

Root cause:

 

this is by design on Microsoft product or maybe is bug :D

When you click on the Alert me you will route to the page sites/abc/_layouts/XXXXX , which is needed read permission at site level.

 

Solution:

 

1. Grant user view permission at site level. > if allow user to see other information

2. If user using client Microsoft outlook 2007 then can direct sync the folder to outlook ( if have any new document upload then you will see unread document at outlook)

3. Admin can help user add the alert.

Using Marco to save file to sharepoint document library :)

 

Just learnt something new from user, which is we can run macro then the excel file can save to SharePoint document library .

 

here is the code :

 

Sub TestSave()
     FolderPath = “http://sharepoint.abc.com/sites/abc/docmentLibrary/”
         SavePath = FolderPath & "sinpeow.xls"
     ActiveWorkbook.SaveAs Filename:=SavePath, FileFormat:=xlNormal
End Sub

How Many current connection to your IIS ?

Recently server is out of memory , so thinking to check and see how many connection is connected to my sharepoint web application.

 

At last have found one counter is under Web services > current Connection.

 

This counter is show how many current connection is connected to your web application.

 

Run Perfmon then add the counter , you will see it.