ORCA Script "connect scc" comment failing

[Shubha]

I am trying to run a simple script to perform the Get Latest
Version automatically.
We use Microsoft Team Foundation for source control.
When I run the script, it gives the following error and
quits at 'scc connect':
If I change it to 'scc connect offline', the script gets
executed.

scc connect
Orca error in 'scc connect '. Result Code -23.
Unable to read SCC connect properties for Microsoft Team
Foundation Server M
An error occurred reading the Windows registry entry.
Last Command Failed.
scc close
You must successfully issue scc connect before you can call
this method.
End Session

Could anyone help with resolving this so that I could
proceed. I tried it for some other scripts too; but it fails
at 'scc connect'. Need to get through that to start using my
scripts.

Thanks in advance.
-Shubha

[Paul Horan[Sybase]]

- Are you able to connect to SCC from within the PowerBuilder IDE?

- Check the registry settings for TFS.
Open the Registry and go to the key HKLM\SOFTWARE\SourceCodeControlProvider
You should have an entry named Microsoft Team Foundation Server MSSCCI
Provider
The data points to another registry key: HKLM\SOFTWARE\Microsoft\Team
Foundation Server MSSCCI Provider

If you go to THAT registry key, you'll see the SCCServerName and
SCCServerPath values. Check to see that those are correct.

From the error message, I think something's getting truncated just after the
"M" in "MSSCCI"...

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

<Shubha> wrote in message news:4a9d5211.31b...@sybase.com...

[Shubha]

Thank You so very much Paul.

Yes I am connected to SCC through PowerBuilder.

I checked the registry entry for SCCServerName and
SCCServerPath values. This is what it has:

SCCServerName Team Foundation Server MSSCCI Provider
SCCServerPath C:\ProgramFiles\Microsoft Foundation
Server MSSCCI Provider\TfsMsscciProvider.dll

And the 'type' entry says REG_SZ

They seem to be correct.

And for the error that is showing up, this is all I can see:

scc connect
Orca error in 'scc connect '. Result Code -23.
Unable to read SCC connect properties for Microsoft Team

Foundation Server Ms
hubha

An error occurred reading the Windows registry entry.
Last Command Failed.
scc close
You must successfully issue scc connect before you can call
this method.
End Session

What could be going wrong. Or is there any particular way to
connect when we have Microsoft Team Foundation Server?

-Shubha

[Paul Horan[Sybase]]

Can you post the contents of your OrcaScript command file?

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

<Shubha> wrote in message news:4a9d9581.391...@sybase.com...

[Shubha]

This is what I have in my command file:

start session
scc get connect properties "C:\PB11\SS_Dev\SS_Shubha.pbw"
scc set connect property provider "Microsoft Team Foundation
Server MD"
scc set connect property localprojpath
"C:\PB11\SS_Dev\SS_Shubha.pbw"
scc set connect property logfile
"C:\PB11\SS_Dev\recompile_SS_Shubha.log"
scc set connect property logappend false
Scc set connect property deletetempfiles "FALSE"
scc connect
scc set target "C:\PB11\SS_Dev\smartsoft.pbt" "outofdate
importonly"
scc refresh target
scc close
end session

I added some extra commands like "scc set connect property
provider "Microsoft Team Foundation Server MD"" to try to
get rid of the error. That's why you would see a few extra
command lines in here.

-Thanks,
Shubha

[Paul Horan[Sybase]]

This line troubles me:

> scc set connect property provider "Microsoft Team Foundation Server MD"

The provider is part of the connect properties already - you shouldn't have
to specifically set it. But if you do, it should exactly match the value
that's in the registry, because that's what OrcaScript is going to look for.
Try removing this line completely. If that still fails, try changing it to

> scc set connect property provider "Microsoft Team Foundation Server MSSCCI
> Provider"

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

<Shubha> wrote in message news:4a9e6fa2.52e...@sybase.com...

[Shubha]

Thanks Paul!
I got the "connect" through, though it gets stuck at the
next command.
This is how it worked
As you had suggested, I changed it to

> scc set connect property provider "Microsoft Team

> Foundation Server MD"

This prompts me for a user name / pwd and when I give that,
it proceeds with the command.
But if I give the line :
> scc set connect property userid "DBCSMART\shubha"
in the command file, the connection fails!

Now where its getting stuck is :
scc set target "C:\PB11\SS_Dev\smartsoft.pbt" "OUTOFDATE |
IMPORTONLY"
Lib List for SccTarget
c:\pb11\ss_dev\grain.pbl
c:\pb11\ss_dev\adv_dw.pbl
.
.
.
.
scc refresh target full

From here it doesn't go forward.
And why doesn't it work when I have the line :

scc set target "C:\PB11\SS_Dev\smartsoft.pbt" "OUTOFDATE |
exclude_checkout"

Thank you so very much for getting me through the 'connect'.
I hadn't been able to do it after so many trials and didn't
have a clue of what was going wrong.

Thank you,
Shubha

[Paul Horan[Sybase]]

> But if I give the line :
>> scc set connect property userid "DBCSMART\shubha"
> in the command file, the connection fails!

Don't try placing the userid and password on the same line. These are two
separate properties.
Add the line:
>> scc set connect property PASSWORD "password"

> scc set target "C:\PB11\SS_Dev\smartsoft.pbt" "OUTOFDATE IMPORTONLY"

These two options are mutually exclusive. IMPORTONLY says "don't bother
checking the SCC repository, just import the existing .SR* files from the
local root folder."
What that's used for is a "bootstrap import", where you are completely
refreshing empty PBLs from your exported source, so checking sync dates is
irrelevant.
That option also benefits from using SCC CONNECT OFFLINE, since there's no
need for a connection to the source control provider to run it.

If you're only syncing the "out of sync" objects, use "OUTOFDATE
EXCLUDE_CHECKOUT"

> And why doesn't it work when I have the line :
> scc set target "C:\PB11\SS_Dev\smartsoft.pbt" "OUTOFDATE |
> exclude_checkout"

That looks OK to me. Define "doesn't work" for me... Is there an error
message?

[Shubha]

Don't try placing the userid and password on the same
> line. These are two separate properties.
> Add the line:
> >> scc set connect property PASSWORD "password"

I did this. But still fails. Gives me the same error as I
had earlier. The one I have entered is the user id (as I giv
it in the pop up that comes up if I don't include username /
password as part of command file).

That looks OK to me. Define "doesn't work" for me... Is
> there an error message?

Yes, there is an error message and the script halts. This is
what I get:

scc connect

scc set target "C:\PB11\SS_Dev\smartsoft.pbt" "OUTOFDATE |

EXCLUDE_CHECKOUT"
Orca error in 'scc set target '. Result Code -27.
Target file not found: C:\PB11\SS_Dev\smartsoft.pbt

Last Command Failed.
scc close

End Session

I don't have this issue when it is "OUTOFDATE IMPORTONLY".
And yes, what I am trying to do is sync the 'out of sync'
objects or in other words a 'get latest version' to get all
the updates made by other developers.

Thank you,
Shubha

[Paul Horan[Sybase]]

> scc set target "C:\PB11\SS_Dev\smartsoft.pbt" "OUTOFDATE |
> EXCLUDE_CHECKOUT"
> Orca error in 'scc set target '. Result Code -27.
> Target file not found: C:\PB11\SS_Dev\smartsoft.pbt

You don't reference the PBT file here, you reference the target NAME.
SCC SET TARGET "smartsoft" "outofdate exclude_checkout"

> I don't have this issue when it is "OUTOFDATE IMPORTONLY".
> And yes, what I am trying to do is sync the 'out of sync'
> objects or in other words a 'get latest version' to get all
> the updates made by other developers.

That's not what IMPORTONLY does. Don't use that command here. Use
Exclude_Checkout.

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

<Shubha> wrote in message news:4a9e9884.58f...@sybase.com...

[Shubha]

Hi Paul,

Setting the target still gives me this error:

scc connect
scc set target "C:\PB11\SS_Dev\smartsoft" "OUTOFDATE |

EXCLUDE_CHECKOUT"
Orca error in 'scc set target '. Result Code -27.
Target file not found: C:\PB11\SS_Dev\smartsoft

Last Command Failed.
scc close
End Session

Isn't it the local target path that should be given here.
This is the target that is added when we initially set up
the source control with PB.

This is the error showing up in the log file:

Source Management Initialization...
Scc Provider: Microsoft Team Foundation Server MSSCCI
Provider
UserID: <ID>
Project Path: <path>
Aux Project Path: <path mentioned here>
Local Project Path: c:\pb11\ss_dev\ss_shubha.pbw

Connection to source control established
PBORCA_SccSetTarget: c:\pb11\ss_dev\smartsoft
Target settings: REFRESH OUT OF DATE | EXCLUDE CHECKOUT
SccGetLatest() failed because object is not under source
control.
Unable to get latest version of c:\pb11\ss_dev\smartsoft
from SCC. Operation cannot continue.
PBORCA_SccClose
9/2/2009 13:41 Source control terminated

Thanks,
Shubha

[Paul Horan[Sybase]]

>>SccGetLatest() failed because object is not under source control.

You have to register the target object itself to SCC. It's a versionable
object just like windows and user objects.

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

<Shubha> wrote in message news:4a9fe60e.74...@sybase.com...

[Shubha]

Thanks Paul.

Looks like the target is not under source control like a few
other objects. I think to proceed with this I have to have
the target under source control - right?
Will let you know if I get this resolved.

I was also wondering why do I get a pop up asking for user
name and password when I run the orca script. I would prefer
it without that since I intend to have it automatically done
during the night, before working hours. Is this some issue
with having Team foundation server ? I would really want to
hear back from you on this.

Thanks,
Shubha

[Paul Horan[Sybase]]

If your OrcaScript file contains the two commands:
SCC Set Connect property UserId <userID>
SCC Set Connect property Password <password>

and you're still getting prompted for userid/password, then this is a bug in
OrcaScript and should be submitted via CaseXpress.

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

<Shubha> wrote in message news:4aa91038.624...@sybase.com...

[Shubha]

Yes Paul my script file has both these commands, but still
it runs into the error :

scc connect
Orca error in 'scc connect '. Result Code -23.
Unable to read SCC connect properties for Microsoft Team

Foundation Server MD
BCSMART\shubha

An error occurred reading the Windows registry entry.

Last Command Failed.
scc close

You must successfully issue scc connect before you can call
this method.
End Session

But if I give the same user name and password when I am
prompted for it (by not having the above 2 lines in the
scriptfile) I get connected.

Please let me know how to submit it as a bug via CaseXpress,
I haven't done it ealier. The link related to caseXpress
talks about some 'Support plan' to submit a bug report?

Thank you,
-Shubha

[Shubha]

Interestingly Paul, I figured out that the same issue had
been reported in this forum almost an year back:

NewsGroup: sybase.public.powerbuilder.source_control
Date: Aug 13,2008 06:57 am
Created by: "Roland Smith [TeamSybase]"
Topic: Re: PB 11.2 Orca and TFS bug? Can't connect

I'm not sure whether it was reported as a bug.
Thought I should mention it here, though. Seems to be an
issue.

Thanks,
Shubha